Tazman,

I don't know if this is exactly what you're looking for, but try setting
conditional formatting on the cells.

Mark

"tazman2168" wrote:

I have formatted multiple cells to SUM when the appropriate data is input.
But until that data is input, it puts a 0(zero) in the cell. Is there any
way to make the cells blank until actual data is input without clearing the
cell of the SUM command?