If your formula is just setting a default value, try something like this
example:

A1: ="100"
Note: A1 will contain the "word" 10, but Excel can still treat it like a
number.

B1: =1*A1
(returns the number 100)

C1: =ISTEXT(A1)
--returns TRUE if the default formula (or text) is in Cell A1
--returns FALSE if a number is in Cell A1

Something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"scott" wrote:

I have a cell that has a formula entered into it. At certain times in the
month of operations this cell with the formual needs to be replaced with a
meter reading. I have the worksheet protected expcept for this cell so people
can enter in the reading.ow is there another formual or way to tell when this
formula has been replaced with the reading, maybe in the form of another
formula in another cell.
Thanks in adavance
Scott