» 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:
- Accounting Principles, with CD, 6th Edition
- Windows XP for Dummies
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Understanding Financial Statements
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
