Formatting The Appearance of Negative Values
-
Select the cell you want to modify.
-
On the Home tab, click Cell, and then click Numeric.
- In the Display Negative as list, select the way you want negative values to appear when printed.
-
Click OK.
|
Negative as |
Display |
|
(x,xxx) |
(5,000) |
|
-x,xxx |
-5,000 |
|
x,xxxCR |
5,000CR |
|
( x,xxx) |
( 5,000) |
Related Topics