How to fix the formulas are showing, instead of the results!

+1 vote
asked Aug 17, 2018 in MS Excel Issues by Mac

I am Mac, can anyone suggest me how to fix the formulas are not showing the issue. I tried to replace the formula lots of time but every time getting the same issue.

1 Answer

0 votes
answered Aug 17, 2018 by lorein0688 (970 points)

Well, this is not a very big issue, it might happen due to the change in formatting your values are not showing. Check whether the cell might be formatted as Text. For changing it select Format > cells and next on the Number tab> select a category other than Text, for example, General or Number.

It might happen the View Formulas option is turned on. And to turn it off in Excel 2010 follow the steps given:

  1. On the Excel Ribbon,> click the Formulas tab > then in the Formula Auditing group > click Show Formulas

Or else in Excel 2003, > select Tools>Options. Then on the View tab, remove the check mark from Formulas.

Tip: The keyboard shortcut to show or hide the formulas is Ctrl +` (the shortcut key is above the Tab key on the keyboard)

That's it!!!

Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.