try

=IF(formula=0, [spacebar], formula)

and by [spacebar], I mean just leave it empty

"samerry" wrote in message
...
I have copied a formula down several rows for future data to be entered and
calculated. In the formula column it shows "0". I would like for the "0"
not
to show. Does anyone know how to make the "0" go away without deleting the
formula. Data will later be entered in the appropriate rows and need to be
calculated at the appropriate time.