Select the cells (the column)
Use Format | Cells ; open Custom; modify the format specs to:
$###0.00;($###0.00)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"puppy_unico" wrote in message
...
Format the selected column so that negative numbers appear like this
($0000.00)