View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Liz Liz is offline
external usenet poster
 
Posts: 133
Default How can I show negative numbers in brackets in spreadsheet

Thank you so much Dave. This is the best solution, which a friend also
suggested. Formatting the cells just didn't work; every time it just reverted
to a minus sign.

"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.

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