Currency format

[Charles Reid]

Hello All,

Is it possible to write a macro to format a cell with the following format
$-100 if the cell has a negative number. The following format in excel for
negative numbers is the following: -$100 or (100).

I know I would have to probably have to convert it to a text string in order
to enter in $ -100.

Any and all help in this matter is greatly appreciated.

 

[Ron Coderre]

From the Excel Main Menu:
<format><cells><number tab>
Category: Custom
Type: $#,##0.00;$-#,##0.00
Click [OK]

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)