» 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:
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Access 2002 for Dummies
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft Excel Version 2002 Step by Step
- The One Page Business Plan: Start With a Vision, Build a Company!
No comments have been submitted.
