Comma format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
Format>Style>Normal>Modify>Custom

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


Gord Dibben MS Excel MVP
 
Back
Top