Number Format Question

[StephenYoo]

Hi,

I need help with formatting number in a cell.

I want to format a cell with "accounting" with negative numbers showing in a red parenthesis, but it only shows with negative sign when I format it with "accounting".

How can I customize the "accounting" format to show negative numbers in red parenthsis?

Thanks.

 

[shg]

Have you tried recording a macro? That's a standard formatting option.

 

[RoryA]

You need to make sure that under the Region and Language options in Control Panel, your number and currency formats use parentheses. Then that will be one of the default formats.