The negative brackets in Excel 2002 version do not appear. Why?

[Guest]

I have tried the suggestions from other users but the brackets do not appear.
This problem is only in Excel 2002 because I have Excel 2003 at work and the
brackets are there.

 

[Jezebel]

Select the cells, go to Format > Cells > Number and select or enter a format
that uses brackets for negative numbers.

 

[Gord Dibben]

Don't know what you have tried but this is the standard fix if negative
brackets are not available in the Number>Negative Numbers dialog.

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)

Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.

Apply and OK>Apply your way out.


Gord Dibben Excel MVP

 

[Guest]

Thank you for your reply. I tried your suggestion you gave to a different
user with the same problem but it didn't work. There seems to be something
different in Excel 2002 that's not letting the brackets show up.

 

[Guest]

Thank you for your reply. I tried this and it seems to work ok.

 

[Gord Dibben]

That's unfortunate.

I can turn this formatting on/off in Excel by following the steps below.

Perhaps the different user did not go to the "Currency" tab in Regional
Options>Customize.

The mistake most users make is they think they should change it under the
"Numbers" tab.


Gord