» 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:
- The Interpretation of Financial Statements
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Writing Excel Macros with VBA, 2nd Edition
- East of Eden (Oprah's Book Club)
- Word 2002: The Complete Reference
No comments have been submitted.
