Thanks Bernard - that is exactly what I was looking for.

_($* #,##0.00_);" "(* (#,##0.00);_(* " "_);_(@_)

This format took away $ signs in the fields I didn't have a value.

This will save me time entering and make the print outs more professional
looking too.

A+ help!




"Bernard Liengme" wrote:

A cell with value 0 formatting as accounting will display: $ -
You could delete the cell ( a blank does not show anything)
You could use Custom format:
Accounting is _-$* #,##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_-
It is the third item _-$* "-"??_-; that is the format for zero
So use _-$* #,##0.00_-;-$* #,##0.00_-;" ";_-@_-

best wishes

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"utahbiker7" wrote in message
...
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