30 June, 2009

Excel displays formula instead of calculating

Here's a new one I just ran into. I entered a new formula into a cell, and it just displayed the formula, instead of calculating the results. It turns out the problem was due to the field being formatted as a Text field. Unfortunately, just by changing the field to a Number does not solve the problem. You must change the field to a Number and then re-enter the formula.

1 comment:

Keith, the Singularity (Keith O Hudson) said...

reformat the cell to "General" -- you won't have to reenter your formula