Click the Column Header for the column of data you wish to format
-Then
Click Format from the file menu
-Then
From the Format Cells dialogue box:
Select the Number Tab
Category = Currency
Decimal Places = 2
Symbol = $
Negative Numbers = ($1,234.10)
-Then
Click OK

"puppy_unico" wrote:

Format the selected column so that negative numbers appear like this ($0000.00)