» 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:
- Microsoft Outlook 2002 for Dummies
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Analysis of Financial Statements
- Marketing Management
- Positioning: The Battle for Your Mind
No comments have been submitted.
