» Hiding the Display of Zero Values
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
The third section in the number custom formatting (after the second ;) returns the formatting for a zero value. To hide the zero value, erase the # and 0 symbols in this section. The formatting will now display an empty cell.
Example:
#,##0_;[Red](#,##0);;
To hide zero values in a sheet:
1. From the Tools menu, select Options, and then select the View tab.
2. Deselect the Zero values checkbox and click OK.
To hide zero values in all cells in the entire workbook:
1. From the sheet tab's shortcut menu, select Select All Sheets.
2. Follow the steps in the previous procedure.

Book Store:
Recommended Books:
- Not-for-Profit Accounting Made Easy
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Windows XP Step by Step (With CD-ROM)
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Financial Peace: Revisited
No comments have been submitted.

