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?
For me, everything was set properly. Format was "general" and calculation options were "automatic". (btw, #2 and #5 in the suggestion are the same) For me, I missed a trailing parenthesis, but Excel didn't show an error like it usually does. I don't know why. So it was #4, "Errors in the forumula".