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.