rrtts
12-08-2006, 11:10 AM
Does anyone know how to fix this...I've tried searching but the nature of the problem is hard to search on without getting tons of erroneous returns. Seems like it should be something easy to figure out, and it probably is...but me being the noob I am, I can't get it.
When I enter a formula in a cell...it runs once and leaves the results in the cell but the formula goes away.
I know this isn't normal because I have other worksheets that do this...but for some reason, this one worksheet is doing it.
For example, if I type =NOW() in a cell...it posts the correct date/time...and that becomes the value of the cell...formula is gone. If I type =A1...it posts the value of cell A1...but formula is gone.
What I'm expecting (like in all my other worksheets) is the formula to display the result but remain in the cell...that way everytime you open the worksheet it computes the formula.
Hope this make sense...please help. Going crazy.
When I enter a formula in a cell...it runs once and leaves the results in the cell but the formula goes away.
I know this isn't normal because I have other worksheets that do this...but for some reason, this one worksheet is doing it.
For example, if I type =NOW() in a cell...it posts the correct date/time...and that becomes the value of the cell...formula is gone. If I type =A1...it posts the value of cell A1...but formula is gone.
What I'm expecting (like in all my other worksheets) is the formula to display the result but remain in the cell...that way everytime you open the worksheet it computes the formula.
Hope this make sense...please help. Going crazy.