-ve number in brackets?

[Doug Boufford]

Office 2000 - XP PRO
I recently switched my Excel to a new computer. On the old comp in
Number Format, there was a choice for -ve numbers to have brackets
around the number. Now all I see is 4 choices - 2 having - preceding in
black & 2 have - preceding in red. This was NOT a custom format but was
shown under Number.
Please advise.
TIA

 

[Gord Dibben]

Doug

If bracketed negatives are not available in Format>Cells>Number.....

This is a function of your Regional Settings in Windows OS.

Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
and select the ($1.1)

Apply and OK>Apply your way out.

You will have to close Excel then re-open to see effects.

You will then be able to choose that format.


Gord Dibben Excel MVP

 

[Doug Boufford]

Gord
I had tried that (twice) before posting but it didn't work. After your
post, I went back in & after 3 tries it now works fine. (Guess I wasn't
holding my tongue correctly)
Thanks for your help
Doug

 

[Gord Dibben]

Go figure!!

Happy you're fixed up anyway.

Thanks for the feedback.


Gord