Go into Tools--Options--View and uncheck Show Zero Values. This should work.
I use it all the time in complex pivot tables, etc.

"samerry" wrote:

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.