You may have a personal preference to display zero values in a cell, or you may be using a spreadsheet that adheres to a set of format standards that requires you to hide zero values. There are several ways to display or hide zero values.
- 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.
Use a number format to hide zero values in selected cells
Follow this procedure to hide zero values in selected cells. If the value in one of these cells changes to a nonzero value, the format of the value will be similar to the general number format.
- Select the cells that contain the zero (0) values that you want to hide.
- On the Home tab, in the Cells group, click Format, and then click Format Cells.
- In the Category list, click Custom.
- In the Type box, type 0;-0;;@
Notes
- The hidden values appear only in the formula bar
— or in the cell if you edit within the cell — and are not printed.
- On the Home tab, in the Cells group, click Format, and then click Format Cells.
- To display hidden values again, select the cells, and then on the Home tab, in the Cells group, point to Format, and click Format Cells. In the Category list, click General to apply the default number format. To redisplay a date or a time, select the appropriate date or time format on the Number tab.
