Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mazza
 
Posts: n/a
Default How do I get negative numbers to show as brackets?


  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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
...



  #3   Report Post  
Nick Hodge
 
Posts: n/a
Default

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
...



  #4   Report Post  
Gordon
 
Posts: n/a
Default

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!
  #5   Report Post  
Gordon
 
Posts: n/a
Default

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


  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
  #7   Report Post  
Gordon
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why cant you show negative numbers in parentheses? Bruce Excel Discussion (Misc queries) 5 December 6th 05 05:26 PM
Converting negative numbers in a range of cells to zero Dede Excel Discussion (Misc queries) 3 January 14th 05 07:23 PM
can the negative numbers in an IF statement be in a diff color th. mwhite17 Excel Worksheet Functions 1 January 12th 05 10:59 PM
Negative Numbers Glenda Excel Discussion (Misc queries) 3 November 26th 04 03:06 PM
Have negative numbers show as zero Domenic Excel Worksheet Functions 0 November 9th 04 05:18 PM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"