How do I get negative numbers to show as brackets?

[Guest]

 

[Peo Sjoblom]

Change the regional settings in windows>start>control panel> regional
settings, there you can change default,
otherwise use a custom format like 0.00_);(0.00)

 

[Nick Hodge]

Mazza

If you want to make a permanent change you can do that via control panel in
windows in regional settings

For a workbook level change you can use a format
(Format>Cells...>Number>Custom), like so.

0.00;(0.00);0

Check here for some help on this

http://www.nickhodge.co.uk/gui/formatmenu/cells.htm#number_tab


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Gordon]

Change the regional settings in windows>start>control panel> regional
settings, there you can change default,
otherwise use a custom format like 0.00_);(0.00)

Sorry, Excel 2002 at least does NOT use the Windows default. You have to
use a custom format.

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!

 

[Gordon]

Mazza

If you want to make a permanent change you can do that via control panel in
windows in regional settings

Sorry, Excel 2002 at least does NOT use the Windows default. You have to
use a custom format.
Lotus DOES however - way to go MS!

 

[Dave Peterson]

I can change this:
windows start button|settings|control panel|regional settings applet
Under the currency tab, negative number format to include ()'s and xl2002 uses
that for me.

 

[Gordon]

I can change this:
windows start button|settings|control panel|regional settings applet
Under the currency tab, negative number format to include ()'s and xl2002 uses
that for me.

Well mine doesn't!