How to you remove the dollar "$ - " formats from each cell that doesn't
have a value entered? If there is no value in the cell, I want the format
"$ -" to not show otherwise they will print on my forms all these $ signs.
I remember in Lotus that it was easy to tell the spreadsheet to ignore the
format if no value was entered. I can not figure out how to do this in
Excel.

Any help would be greatly appreciated.

Thanks