hi, i have cells that are formatted for accounting and the cell formula
contains the SUM feature, when the cells are empty and waiting for a value,
they display ($ -) and so i have those symblos everywhere and would like the
cell just to be blank and then show up with the dollar sign when a value
appears in it.

Any ideas?
thanks