View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default excel 2003 no brackets in number format

I'd try it again.

It works ok for me in WinXP and xl2003.



AndrewM wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson