Regional Options from control panel not displayed in Format Cells

[Guest]

Please can somone help me. I have searched on this topic but Alas I can not
find an answer. So here is my question.

When you set your number formats under control panel -> Regional options
they are the ones EXCEL should use for formatting. My example is I want
Parenthesis around my negative numbers ( ) . I do not want a - sign infront
of number or it to be RED.

So I have set my negative number symbol to () under the regional options.

But if you start Excel and put in a negative number then goto Format cells
-> numbers the option STILL show only a - or RED. I.E. it does not give the
option for ( )'s

Now I can create a custom format to overcome this. BUT it is a work around.
So please no replies telling me how to #,##0;(#,##0)

I want the number format to show in its negative number list to show
(1234.10) etc..

The annoying thing is one of my PC's shows it as above the other 3 do not.

I have changed default to antoher country rebooted and put is back again
etc..

Please can anyoune help or explain why 1 PC has them correct and the other 3
do not and I have to create the custom one every time.

Thanks in advance.

 

[Jim Rech]

If you change your CURRENCY number format under Control Panel to use parens
for negatives then when you restart Excel it will have the parens option in
the Format, Cells, Number, Number, Negative Numbers list.

--
Jim Rech
Excel MVP
| Please can somone help me. I have searched on this topic but Alas I can
not
| find an answer. So here is my question.
|
| When you set your number formats under control panel -> Regional options
| they are the ones EXCEL should use for formatting. My example is I want
| Parenthesis around my negative numbers ( ) . I do not want a - sign
infront
| of number or it to be RED.
|
| So I have set my negative number symbol to () under the regional options.
|
| But if you start Excel and put in a negative number then goto Format cells
| -> numbers the option STILL show only a - or RED. I.E. it does not give
the
| option for ( )'s
|
| Now I can create a custom format to overcome this. BUT it is a work
around.
| So please no replies telling me how to #,##0;(#,##0)
|
| I want the number format to show in its negative number list to show
| (1234.10) etc..
|
| The annoying thing is one of my PC's shows it as above the other 3 do not.
|
| I have changed default to antoher country rebooted and put is back again
| etc..
|
| Please can anyoune help or explain why 1 PC has them correct and the other
3
| do not and I have to create the custom one every time.
|
| Thanks in advance.