Negative number formatting

  • Thread starter Thread starter VickyJones
  • Start date Start date
V

VickyJones

Hi everyone, does anyone know how to do this? I hve a column of figures
some positive and some negative. I want to format them so taht th
negative numbers are expressed in (brackets) and also so that th
column itself is decimal aligned, so even if I don't use decimal place
the brackets "stick out". I know Word does this in tables, but I can'
seem to make Excel do it. Help! Thanks, Vicky. :confused
 
How about a custom format of:

#,##0.00_);(#,##0.00);0.00_);@

It uses two decimal spots and whole numbers will be shown like 7.00.
 
Back
Top