|  

» Formatting a Negative Number with Parentheses

To add parentheses to the display of negative numbers:

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 syntax for customized formatting:
#,##0 ;[Red](#,##0);- ;

Result:
• Original number: -3,453,453
• The displaying formatting number: (3,453,453)
Note: The number formatting syntax is:
Positive; Negative; 0; Text
Screenshot // Formatting a Negative Number with Parentheses
Formatting a Negative Number with Parentheses

Rate This Tip
12 34 5
Rating: 3.68     Views: 121068
No comments have been submitted.
Name
Comment Title
Comments