Yes. You are now beginning to understand what we've been saying. When
someone overtypes the formula with data, the formula isn't there in the cell
any more. It has gone. It is no longer a formula. You no longer have a
formula. You have data instead of the formula. The cell can't contain both
data and formula at the same time. It can contain only one or the other,
not both.
--
David Biddulph

lauraroebuck wrote:
Thanks Simon but his doesn't work either as if they overtype then
delete it still deletes the formula. I want the formula to be
protected from being deleted. Starting to think it is not possible!