How can I prevent loosing formula during data entry?
 

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......

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......

if the data is being entered in the wrong cell, You should concider
protecting cells except those available for data entry.

Being a klutz, I do this even on stuff I do only for myself.

"Thomas Jacob" wrote:

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......