excel 2003 no brackets in number format

[AndrewM]

Excel 2003 does not display the option to format negative numbers in the
numbers format option. It shows two options both are with "-"

 

[Dave Peterson]

You could change the format of the cell, but if you want the ()'s to show up for
negative numbers in the format|cells|number tab, you'll have to change a windows
setting.

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.

 

[AndrewM]

Already tried this route and has no effect on Excel.
In excel 200 under the format currency it showed up with 4 options, one set
with brackets and one with minus symbol. Now all I see is the minus symbol.

Andrew

 

[Dave Peterson]

I'd try it again.

It works ok for me in WinXP and xl2003.

 

[AndrewM]

Dave
I had to change the format option under currency as well and then it worked.
Thanks
Andrew

 

[Dave Peterson]

Actually, you only had to change the format under the currency tab:

You can change the format on the Number tab back to what it was before.

Dave
I had to change the format option under currency as well and then it worked.
Thanks
Andrew