Microsoft Excel Puzzle - please help

[puppy_unico]

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

 

[Peo Sjoblom]

$#,##0.00_);($#,##0.00)


--


Regards,


Peo Sjoblom

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom: General;($0000.00)

 

[Bernard Liengme]

Select the cells (the column)
Use Format | Cells ; open Custom; modify the format specs to:
$###0.00;($###0.00)
best wishes

 

[RayportingMonkey]

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

 

[RayportingMonkey]

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