View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default format cells that will show the data in parenthesis

An example would have been very useful. Assuming it's negative numbers you
want to parenthesize, use a custom format of:
#,##0.00;(#,##0.00)

Regards,
Fred

"Hoop" wrote in message
...
I would like to format some cells that I put data into to be in ( )
Parentesis.. How do I do this?