Microsoft Excel Puzzle - please help
 

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

Microsoft Excel Puzzle - please help
 

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


--


Regards,


Peo Sjoblom


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

Microsoft Excel Puzzle - please help
 

One way:

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

In article ,
puppy_unico wrote:

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

Microsoft Excel Puzzle - please help
 

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)

Microsoft Excel Puzzle - please help
 

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)

Microsoft Excel Puzzle - please help
 

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)