This is a common question we get asked from a lot of Excel users, how do you not display a zero in a cell. It very simple to turn off a zero value by following the directions below.
- Click the Microsoft Office Button , click Excel Options, and then click the Advanced category.
- Under Display options for this worksheet, select a worksheet, and then do one of the following:
- To display zero (0) values in cells, select the Show a zero in cells that have zero value check box.
- To display zero values as blank cells, clear the Show a zero in cells that have zero value check box.