Thread: How can I show negative numbers in brackets in spreadsheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How can I show negative numbers in brackets in spreadsheet
Format/ Cells/ Custom.
--
David Biddulph

"Liz" wrote in message
...
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?



Reply With QuoteReply With Quote