Display or Hide Zeroes

By default, Excel displays the data as it is typed in. This includes zero values.

To control the display of typed zero values;

Click the Office Button
Click Excel Options at the bottom of the screen
Select Advanced
Scroll down to Display options for this worksheet section
Go to Show a zero in cells that have a zero value
    Checked box displays zero value on screen and printout (recommended option)
    Unchecked box displays no zero value
OK to save the changes

 

Updated:  November 18, 2009
 
 Sr. Arlene Callahan
 Training Manager
 Rivier College
 Nashua, NH 03060
 Phone: 603.897.8660
 E-mail: acallahan@rivier.edu