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



One thought on “Formatting a Negative Number with Parentheses

Leave a Reply

Your email address will not be published. Required fields are marked *


× five = 30

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>