Protecting your formula cells as suggested by Pete_UK will protect your
formulas.

If you want to suppress the formulas from displaying 0's (zeroes) when the
source data has been removed you can do that by clicking on TOOLS/OPTIONS.
Click the VIEW tab and towards teh bottom of the tab page there are 3 columns
of check boxes, remove the check from the check box labeled ZERO VALUES
(located in the center column at the bottom) to suppress 0's from displaying.
--
Kevin Backmann


"Pete_UK" wrote:

The cell will be locked by default, but you need to protect the
worksheet for this to take effect - Tools | Protection | Protect
worksheet. You have an option to provide a password if you wish, but
if you do then write it down somewhere so you don't have to come back
here asking how to unprotect it having lost your password !!

This will prevent accidental erasure of the formula.

Hope this helps.

Pete

On Nov 19, 9:12 pm, SliderSteve
wrote:
I have been asked to look at a pronblem with a colleagues spreadsheet in
Excel. When you clear data within a cell, so new data can be added the
formula for teh cell has also been deleted.

Is there a way to set cells to maintain underlying formulas by default?