-ve number in brackets?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug Boufford - 22 Feb 2005 16:23 GMT

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

Reply to this Message

Gord Dibben - 22 Feb 2005 18:25 GMT

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

>Office 2000 - XP PRO
>I recently switched my Excel to a new computer. On the old comp in
[quoted text clipped - 4 lines]
>Please advise.
>TIA

Reply to this Message

Doug Boufford - 22 Feb 2005 20:57 GMT

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

> Doug
>
[quoted text clipped - 22 lines]
>>Please advise.
>>TIA

Reply to this Message

Gord Dibben - 22 Feb 2005 23:10 GMT

Go figure!!

Happy you're fixed up anyway.

Thanks for the feedback.

Gord

>Gord
>I had tried that (twice) before posting but it didn't work. After your
[quoted text clipped - 29 lines]
>>>Please advise.
>>>TIA

Reply to this Message