Why does my spreadsheet show a formula instead of calculating it?
Quick answer
In Excel, first check whether Show Formulas is on: it can make formulas appear across a worksheet instead of showing results. If only one or a few cells are affected, check whether they’re formatted as Text or the formula was entered without an initial equals sign. For a formula that is visible but not updating, check calculation mode. For a text-formatted formula, change it to General and re-enter it. [S1] [S2]
The question, the details, the next step.
Why does my spreadsheet show a formula instead of calculating it? I see something like =A1+B1 in a cell, but I expected a number.
The quickest way to narrow it down is to notice how widespread the problem is. If formulas show across much of the worksheet, check whether Excel’s Show Formulas control is enabled; it switches between displaying formulas and their calculated results. [S1]
If just one or a few cells show formula text, check those cells individually for text formatting or a missing initial equals sign. Those are also listed as reasons Excel may display a formula as text. [S2]
It’s happening in one cell. What should I check first?
Select the affected cell and look at its number format. If it is set to Text, change it to General, then re-enter the formula. Microsoft’s guidance for a text-formatted formula is to change the cell to General and re-enter it. [S2]
For example, if the cell contains =A1+B1, select it, set its format to General, then edit the entry and confirm it again. Check that it begins with =. If the cell still displays the formula, continue with the worksheet-wide display check.
How can I tell whether Show Formulas is the issue?
Compare a few cells that contain formulas. If the sheet is showing formula expressions in many places rather than their results, Show Formulas is a setting to check. Excel’s control toggles the worksheet between those two views, and Microsoft also documents a keyboard toggle. [S1]
Turn off Show Formulas using Excel’s control or its documented keyboard toggle, then check whether the cells display results. If only the original cell still shows its formula, return to its format and entry. A worksheet-wide display setting and a text-formatted individual cell are different causes, so fixing one may not fix the other.
The formula is visible, but its result seems out of date. Is that the same problem?
Not necessarily. If Excel is displaying the formula itself, investigate Show Formulas or the cell’s text format. If you can see the calculated result but it is not updating as expected, check calculation mode: Microsoft notes that formulas will not calculate when manual calculation is enabled. [S2]
Treat that as a separate check from re-entering a text-formatted formula. First establish whether you are looking at formula text or a result, then investigate the relevant setting. The supplied guidance identifies manual calculation as a possible cause, but does not establish what setting is currently active in your workbook.
Can you give me a short order of operations so I don’t keep changing random settings?
Use this sequence and stop when the display behaves as expected:
- Check whether formulas appear throughout the worksheet. If they do, check Show Formulas and switch back to results if it is enabled. [S1]
- If only particular cells are affected, inspect their format. For Text, change to General and re-enter the formula. [S2]
- Confirm the entry starts with
=. [S2] - If results are visible but not updating, check whether calculation mode is set to manual. [S2]
For a made-up example, suppose =A1+B1 appears only in cell C1. Check C1’s format, change Text to General if needed, and re-enter =A1+B1. If many formula cells display expressions, check Show Formulas before editing each cell. This order distinguishes a display setting from an entry or calculation issue.
A practical checklist
Notice whether formula text appears across the worksheet or only in particular cells.
If formulas appear throughout, check Excel’s Show Formulas control.
For an affected individual cell, check whether its format is Text.
If needed, change the cell to General and re-enter the formula.
Check that the formula begins with an equals sign.
If results are visible but not updating, check calculation mode.
A few more useful answers
Will changing a cell from Text to General automatically fix the formula already in it?
Not necessarily. Microsoft’s suggested correction is to change the cell to General and re-enter the formula. [S2]
What if the formula appears in many cells at once?
Check Show Formulas first; Excel’s control can display formulas instead of their calculated results across the worksheet. [S1]
What if I see a result, but it is not recalculating?
Check whether calculation mode is manual. Microsoft lists manual calculation as a reason formulas may not calculate. [S2]
Sources
References used for this guide.
- [S1] Display or hide formulas in Excel support.microsoft.com · Checked
- [S2] How to avoid broken formulas in Excel support.microsoft.com · Checked