A
AndrewM
Excel 2003 does not display the option to format negative numbers in the
numbers format option. It shows two options both are with "-"
numbers format option. It shows two options both are with "-"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
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.
A
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
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
D
Dave Peterson
I'd try it again.
It works ok for me in WinXP and xl2003.
It works ok for me in WinXP and xl2003.
A
AndrewM
Dave
I had to change the format option under currency as well and then it worked.
Thanks
Andrew
I had to change the format option under currency as well and then it worked.
Thanks
Andrew
D
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.
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