First of all, you cannot have a formula and manual entry in the same cell.

No version of Excel will allow that...........manual entry overwrites the
formula.

You must have a formula that references the input cell or cells.

Secondly..................

I don't think you understand all you need about locking and protecting.

You can lock some cells and leave other unlocked.

By default all cells are locked.

Unlock all cells then select the ones to have locked and format them to
locked.

Now protect the sheet.

I think Excel 95 had that feature but long time since I used Excel 95


Gord Dibben MS Excel MVP


On Thu, 14 Jan 2010 13:47:01 -0800, 'Cia
wrote:

My stepdad is using a really old version of Excel. He would like to allow his
church secretary to input data but not delete formulas. (He has his formulas
typed into the same cells she would change). So is there a way to
protect/lock these cells, so that the formulas stay intact? I have read many
posts about locking and protecting, so we understand all that, but doesn't
seem to take care of his problem. He doesn't want to lock the cells, because
then she can't input numbers. Is the only answer to type formulas in a
different cell that references the cell that she types into?