How do I get negative numbers to show as brackets?
 

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


--

Regards,

Peo Sjoblom


"mazza" wrote in message
...

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
(FormatCells...NumberCustom), like so.

0.00;(0.00);0

Check here for some help on this

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


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"mazza" wrote in message
...

Peo Sjoblom wrote:
Change the regional settings in windowsstartcontrol 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!

Nick Hodge wrote:
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!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

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 wrote:

Nick Hodge wrote:
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!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

--

Dave Peterson

Dave Peterson wrote:
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!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk