Hide cell contents with semicolons
In Excel, you can use semicolons in Format Cells to control whether or not text and numbers are displayed.
![](https://static.wixstatic.com/media/af7fa4_84dc2a7f34cd4a838f4c74f638416bba~mv2.png/v1/fill/w_980,h_679,al_c,q_90,usm_0.66_1.00_0.01,enc_avif,quality_auto/af7fa4_84dc2a7f34cd4a838f4c74f638416bba~mv2.png)
Entering two semicolons in the Custom category on the Number tab will hide the contents of any cells which contain only positive or negative numbers:
![](https://static.wixstatic.com/media/af7fa4_835550eb842d42e2a808cc4af994ad2b~mv2.png/v1/fill/w_973,h_664,al_c,q_90,enc_avif,quality_auto/af7fa4_835550eb842d42e2a808cc4af994ad2b~mv2.png)
Entering three semicolons will hide the text and numbers:
![](https://static.wixstatic.com/media/af7fa4_37872117f9384ba2a3bdee28ba6efcff~mv2.png/v1/fill/w_957,h_778,al_c,q_90,enc_avif,quality_auto/af7fa4_37872117f9384ba2a3bdee28ba6efcff~mv2.png)