We can leave a cell blank if the value in it is zero by formatting the cell to remove the zero value. This tutorial will teach us how to leave cell blank if zero.
Figure 1: If zero leave blank
If Cell is Blank then Leave Blank
- To do this, we will prepare our table of values including all the zero figures present in the data.
Figure 2: Data for if 0 leave blank
We will highlight the entire range A4:C10 and right-click to select format cells. In the Format cell dialog box, we will click on custom, then we will select the general and type a double semicolon “;;” in front of the word general and we will then click OK.
Figure 3: Dialog box for leaving zero(s) as blank
- This will tell excel that if cell is blank, do nothing. It will also wipe out all the zeros on our table, leaving their cells blank
Figure 4: Leaving Zeros Blank
Instant Connection to an Expert through our Excelchat Service
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.