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
Wednesday, June 3, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment