Formulas Appearing in Cell Instead of Result - EXCEL for iMac
This is driving me crazy. Sometimes, I enter a formula and it only shows the formula, not the result. How can this be fixed to return the RESULT in the cell instead of the reiteration of the formula I just entered?
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
Check the cell formatting (Ctrl+1 > Number) and make sure that it's not formatted as Text. If it is, then change the format to something else, then F2 > Enter on the cell to coerce the format change and calculate.
Every once in a while there's a sudden gust of gravity...
7 people were helped by this reply
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.