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 can I show negative numbers in brackets in spreadsheet

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.

Liz wrote:

If I type (75) for minus 75 the number always appears -75 and not (75). Even
in 'Format cells' the brackets option for minus numbers is not an option.
How can I show minus numbers in brackets?


--

Dave Peterson