Displaying Zeros

By default, Excel displays your information pretty much as you enter it. This includes zero values. If you enter a zero, the zero shows on the worksheet. If you don't enter a value in a cell, then Excel shows a blank in that area. If the result of a formula is zero, then that result typically shows, as well. There may be times, however, when you don't want zero values to show. To control the display of zero values, follow these steps:

1. Choose Options from the Tools menu. This displays the Options dialog box.
2. Make sure the View tab is selected. (Click here to see a related figure.)
3. In the Window Options area, note the Zero Values check box. If it is selected, then zero values are displayed. If it is cleared, then zero values are not displayed.
4. Click on OK.

You should note that the setting of the Zero Values check box affects not just what you see on the screen, but how information is printed by Excel, as well.