How can I get the Negative Numbers dispalyed in brackets in Excel 2003

[Edward S]

I have just started using MS Excel 2003 and noticed that the use of
brackets i.e. ()has been discontinued. example minus 2,000.00 as
(2,000.00) in Red

How can I have it restored. I tried it through the regional settings
and it still does not work. Can someone point me in the right
direction

Many Thanks
Edward

 

[Max]

Try this:

Select the col or cell(s) to be formatted

Click Format > Cells > Number tab > Custom (under Category)

Under the "Type:" box

Scroll down and select:

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

(or just paste the above direct into the "Type:" box)

Click OK

 

[BrianB]

Format Cells/Number/Custom then copy/paste this :-
#,##0;[Red](#,##0); ;

You can then change it further as you wish

 

[Edward S]

Format Cells/Number/Custom then copy/paste this :-
#,##0;[Red](#,##0); ;

You can then change it further as you wish.

Thanks guys

Edward

 

[Max]

You're welcome, Edward !
Thanks for the feedback

 

[Guest]

This is an excellent tip and I was able to massage my data to black print by removing the [Red] and adding a $ sign within the (brackets

----- BrianB > wrote: ----

Format Cells/Number/Custom then copy/paste this :
#,##0;[Red](#,##0);

You can then change it further as you wish