Excel Cell Formatting question

T

Tom Bradstreet

I am using MS Excel 2003 SP1.
I would like to have negative numbers display as red and in brackets
)

Any help would be greatly appreciated.

Thanks
To
 
K

kkknie

Select the range you want to format and go to the Format menu, selec
Cells. Then select the Number tab and select your number of decima
places and the format for negative numbers (it's the bottom one of th
4 on my screen).
 
G

Gord Dibben

Tom

Do you not have that option in Format>Cells>Number "negative numbers" section?

If not, create a new Style from Format>Style>Normal "Modify">Custom. Pick a
style from the Custom dialog and OK your way out.

#,##0_);[Red](#,##0) or the one with two decimal places if desired.

#,##0.00_);[Red](#,##0.00)

Gord Dibben Excel MVP
 
Top