View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to show brackets around a negative number

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.

Afsha wrote:

I have a negative number in a math calulation in Excel. I would like the cell
to automatically put brackets around this or to be able to format it this
way.... I have gone into Format/Cells/Number, but cannot find a way of doing
this here....

Any suggestions?


--

Dave Peterson