You don't. The formula produces a result and that is what is displayed.
You could possibly change all the font colors to match the background color
or you could adjust all your formulas to do something like this

=if(A1<"",currentformula,"")

then if you cleared A1, all cells would look blank.

You could use a similar construct to appear blank if the formula returns a
zero.

=if(A1<"",if(currentformula=0,"",currentformula), "")


--
Regards,
Tom Ogilvy

"Flopp2" wrote in message
...
How do you clear the contents of a cell but keep the formula? Also, how
do I
program that if answer is 0 then leave cell blank instead of putting in
the
zeros? Thank you