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.

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)




"Charles Reid" <(E-Mail Removed)> wrote in message
news:46ef2053$0$17073$(E-Mail Removed)...
> 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.
>