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.
You might be asking “When excel shows formula instead of value?”
The most usefull answer is: what to Do when Excel Shows Formulas Instead of the Calculated Values. Here are the steps to show formulas in Excel instead of the value: Click on the ‘Formulas’ Tab in the ribbon. In the Formula Auditing group, click on the Show Formulas option.
Why are formulas showing as formulas in Excel?
The next reason why formulas are shown as formulas: You may have set the cell formatting to “Text ” and then typed the formula in it. When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it. To fix this error, just select the cell, set its formatting to “General”.
How do you show calculated value instead of formula in Excel?
Therefore, if you enter a formula that links one cell to a cell formatted as text, the cell with the formula is also formatted as text. To display the calculated value rather than the formula, you must change the format of the cell containing the formula and re-enter the formula.
Why Excel is not calculating a result?
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.
How to stop Excel from showing formulas in cells instead of results?
If you are using Excel 2013 Than do the following File > Option > Advanced > Under Display options for this worksheet: uncheck the checkbox before Show formulas in cells instead of their calculated results This should resolve the issue. Show activity on this post.
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.
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?
One source argued that Below are the steps to do this: 1 Click the Formulas tab 2 In the Formula Auditing group, click on Show Formulas.