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?
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.
HTH
Every once in a while there's a sudden gust of gravity...
15 people found this reply helpful
·
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.