Comma format

Raj · Apr 17, 2007

How do I set the default comma format to show negative number as within
paranthesis. say -1234.567 as (1,234.57)

Can anyone help please ?

Gord Dibben · Apr 17, 2007

Format>Style>Normal>Modify>Custom

#,##0.00_);[Red](#,##0.00)

Gord Dibben MS Excel MVP