A cell can only contain either data (input) or a formula, not both.

You should normally enter the data where the formula points to, e.g.: if the
formula in C1 is: =SUM(A1:B1),
then data (i.e. numbers) could be entered into A1 and B1, and C1 will then
compute the total ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Thomas Jacob" <Thomas wrote in message
...
I have a work book that has data containing formulas. while editing
the
same , on some cells, it was found that the formula is getting lost during
data entry....Can some one help me on this please......