to Tom Ogilvy : )

  • Thread starter Thread starter chengj
  • Start date Start date
C

chengj

whould you tell me how to :" format the cell with
parentheses for positive or all values"
I cann,t find where to set this property
:)
thank you!
 
Cheng,

Format | Cells Number Tab, Custom category, then you can use

(#,##0);[Red](#,##0)

or similar, depending on how you want decimals handled.

This will result in positive numbers in parens, and negative numbers
in red and in parens.

HTH,
Bernie
MS Excel MVP
 
Back
Top