View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can I display negative numbers with parenthases in Excel?

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.

Nicole wrote:

Everytime I go to Format -- Cells -- Number or Currency, I can never get
the ( ) option to show up for negative numbers! HELP!!!!!!


--

Dave Peterson