Formatting The Appearance of Negative Values

1. Select the cell you want to modify.

2. On the Home tab, click Cell, and then click Numeric.

3. In the Display Negative as list, select the way you want negative values to appear when printed.

4. Click OK.

Negative as	Display
(x,xxx)	(5,000)
-x,xxx	-5,000
x,xxxCR	5,000CR
( x,xxx)	( 5,000)

Related Topics

• About Cell Formatting
• Formatting the Appearance of Positive Values
• Formatting the Appearance of Zero Values