View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default displaying numbers in parentheses

Use custom format

0.00_);(0.00)


--


Regards,


Peo Sjoblom



"zanny101" wrote in message
...
I would like to display numbers in parentheses but excel automatically
reads
it as a formula. Is there a way of formatting the cell so that such
numbers
can be displayed? For example I want to enter: -0.15 (1.20)
thanks!
--
zanny101