Number format lost?

[Frankyboy]

Hello,

When I want to format a number in Excel, I usually go in Format-Cell-Number
and I got the choice of
-how many decimals
-thousand separator
and a choice of display for negatives format like this:
-1234.56
1234.56 in red
(1234.56)
(1234.56) in red

but since a few days I have lost parentheses in that box like this:
-1234.56
1234.56 in red
-1234.56
1234.56 in red

What happened? How can I restore it the way it was?

 

[Frank Kabel]

Hi
this setting depends on your regional Windows settings

 

[Frankyboy]

I tried this and this is not working!

Hi
this setting depends on your regional Windows settings

 

[Dave Peterson]

Which setting did you try?

The way I'd get to in Win98 is:

Windows Start button|settings|control panel|Regional Settings
Currency Tab|Negative Number Format

 

[Gord Dibben]

I would get it this way in Windows XP

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.

Gord Dibben Excel MVP