How do I get brackets around negative numbers?

  • Thread starter Thread starter Gordon
  • Start date Start date
G

Gordon

Valtam said:
My regional setting in Windows XP Home shows negative number format
to be in brackets yet the number format in Excel 2003 still does not
show the bracket option?
Click to expand...

Have you tried the Custom format?
 
My regional setting in Windows XP Home shows negative number format to be in
brackets yet the number format in Excel 2003 still does not show the bracket
option?
 
This is a windows setting.

Close excel

Change that windows regional setting|currency tab|Negative currency format
to show ($1.1)

Open excel

You may have to reformat:
Format|Cells|number tab|Number
(adjust the decimal places and comma options)
 
Valtam

Set Currency for brackets in Regional Settings. Number alone won't do the
trick.


Gord Dibben Excel MVP
 
Gord said:
Valtam

Set Currency for brackets in Regional Settings. Number alone won't
do the trick.


Gord Dibben Excel MVP
Click to expand...

Umm the OP said he'd already done that........
 
Maybe the OP looked at the Numbers tab, not the Currency tab (under the regional
settings applet).
 
Gordon

Ummm. Re-read the original. Quoted below.
My regional setting in Windows XP Home shows negative number format to be in
brackets yet the number format in Excel 2003 still does not show the bracket
option?
Click to expand...

I see no mention of the Currency Setting in Regional Options.


Other Gord
 
Gord said:
Gordon

Ummm. Re-read the original. Quoted below.


I see no mention of the Currency Setting in Regional Options.


Other Gord
Click to expand...

So who introduced Currency? Not me!
 
I had only set the numbers to brackets. I had not even noticed the currency
tab. Have now set the currency tab to brackets and Excel is now working
exactly how I want. Many thanks to all who have responded to my question.
 
Valtam

Glad you're sorted out.

It is not intuitive to go to the Currency Tab when you are thinking "numbers".

Has confused many and I assume will continue to do so until/unless the two are
tied together.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel not using regional settings 6
Displaying negatives with (brackets) 3
Spreadsheets: negative numbers in brackets 2
How to show brackets around a negative number 2
Option to put brackets around negative numbers not available in 20 3
Negative Numbers in Brackets - HELP! 21
How do I align numbers in different cells when some are in bracke. 2
Negative Numbers in Brackets 2

Back
Top