to Tom Ogilvy : )

[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!

 

[Bernie Deitrick]

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