» 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:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Marketing Management
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
how to leave a formatted cell blank
Jeremy Posted on: 31-12-1969
I have a spreadsheet with multiple columns, specifically I am dealing with species of plants. The last column in the sheet gives the overall % each species occupies out of 100%. How do I leave the cells formatted and prevent 0% from showing up. The table is too confusing with all the 0%'s and it is not necessary for me to show 0%. Thanks for your time.Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
