Forum Discussion
Formulas displaying as text
Can anyone tell me why my worksheet allows me to type in formulas one minute but then suddenly starts to display the formulas as text and won't do the calculations?
I was frustrated yesteday. Finally, I recreated a new column, and then followed instructions. And results showed. I then deleted the original columns
This is frustrating. It has happened to many times, and I do create a new column as above, or sometimes I re-enter on another row of the same column and it works. I think there is some kind of non-printable character gets into the formula.
- Check your formatting. In my case, when I make new rows or columns, sometimes it copies the formatting of the neighboring row/column and formats everything as TEXT (because that's what the previous column was set as). That's what breaks my formulas, until I catch it.
