OR- without the comma, do like this

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 = Custom
Type = $###0.00_);[Red]($###0.00)
-Then
Click OK




"RayportingMonkey" wrote:

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)