There’s a setting that makes Excel display formulas only instead of their results. This setting might have been enabled in your spreadsheet somehow. To change it back, use this shortcut: If an empty cell is formatted as text, then when you type the formula and hit enter, it will never show the result.
[Solution] Excel Formula Shows Formula but not Result
No equal sign. First, you may have forgotten the equal sign. Space before equal sign. A subtle variation of this problem can occur if there is one Formula wrapped in quotes. Finally, make sure the formula is not wrapped in quotes. A few extra things to look into: finally, every once in a while, see more, and cell format set to text.
Every once in a while, you might find Excel behaving in a bizarre or unexpected way. One example is when you accidentally trigger the scroll lock feature. Another example is when one or more formulas suddenly stops working.
Why is the formula displayed instead of the result?
The formula is entered but the formula is displayed instead of the result. A cell in an Excel worksheet can have many formats and the default format of all cells in a new sheet is General (which would not cause this problem). Hence, a possible reason could be that the cell in which the formula is entered is formatted as Text. What’s the fix?
What does show formulas mean in Excel?
Show Formulas is enabled. Excel has a feature called Show Formulas that toggles the display of formula results and actual formulas . Show Formulas is mean to give you a quick way to see all formulas in a worksheet.
How to recover calculated formulas in Excel without the result?
You can try Stellar Repair for Excel software to recover engineering and shared formulas. Sometimes, when you type a formula in a cell of worksheet and press Enter, instead of showing the calculated result, it returns the formula as text. For instance, Excel cell shows: Why Does Excel Show or Display the Formula Not the Result?
This begs the query “How do I turn off all formulas in Excel?”
To disable this mode, go to ‘ Formulas ’ and click on ‘ Show formula enabled .’ If it’s previously enabled, it will be disabled by just clicking on it. Another possible reason that only formula shows in Excel not result could be that the cell format is set to text.