» Replacing Zeros with Dashes in Number Formatting
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
1. Press Ctrl+1 to open the Format Cells dialog box.
2. Select the Number tab, and from Category, select Custom.
3. In the Type box, enter the following Custom Formatting syntax:
#,##0 ;[Red](#,##0);- ;
Note:
The number formatting syntax is:
Positive; Negative; 0; Text
Book Store:
Recommended Books:
- Financial Reporting and Analysis (2nd Edition)
- Analysis of Financial Statements
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Microsoft Windows XP Registry Guide
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Yes, You Can Time the Market!
No comments have been submitted.
