A cell can contain either a formula or a constant value, not
both. There is no way to "clear a cell and keep the formula".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"genevieveg"
wrote
in message
...

hi Im new to excel I seem to lose my formula's everytime I go
back to
enter some data that I may enter wrong for example I have put
the
formula in and go back and put a number in the cell and find
it's the
wrong # so I backspace or hit delete and I lose my formula and
clear
the cell what am I doing wrong??:)


--
genevieveg
------------------------------------------------------------------------
genevieveg's Profile:
http://www.excelforum.com/member.php...o&userid=30333
View this thread:
http://www.excelforum.com/showthread...hreadid=499995