• About Cell Formatting
• Conditional Formatting
• Adjusting Cell Height
• Adjusting Cell Width
• Aligning a Column of Cells
• Aligning Numbers and Text in a Cell
• Capitalizing Cell Contents
• Changing a Cell's Font
• Changing a Cell's Type
• Changing The Separator for Date Cells
• Creating a User Defined Underline
• Defining Cell Options Globally
• Distributing Cell Contents Evenly
• Formatting The Appearance of Negative Values
• Formatting The Appearance of Positive Values
• Formatting The Appearance of Zero Values
• Printing a Currency Sign Inside a Cell
• Separating Large Currency Values with a Comma
• Shading a Cell
• Shading a Column of Cells in Form Mode
• Shading Multiple Cells
• Underlining a Cell
• Underlining The Currency Symbol

Formatting The Appearance of Zero Values

1. Select the cell you want to modify.

2. On the Home tab, click Cell, and then click Numeric.

3. In the Display Zero as list, select the way you want zero values to appear when printed.

4. Click OK.

Related Topics

• About Cell Formatting
• Formatting The Appearance of Positive Values
• Formatting The Appearance of Negative Values