How To Fix Excel Formulas Not Calculating Or Showing Text (2026)
When an Excel cell shows the formula itself, or keeps an old result, the cause is almost always one of a few settings.
Which one applies depends on what you see in the cell, so the table below matches the symptom to the fix.
The steps come from Microsoft’s support pages, and none of them require changing the formula itself.
Quick answer: match the symptom to the fix
| What you see | Likely cause | Fix |
|---|---|---|
| Every formula on the sheet shows as text | Show Formulas is on | Formulas tab > Show Formulas, or Ctrl + ` |
| One cell shows the formula text | Cell is formatted as Text | Format Cells > General, then F2 and Enter |
| Results do not update when you change a number | Calculation is set to Manual | File > Options > Formulas > Automatic |
| The cell shows SUM(A1:A10) as plain text | No leading equal sign | Start the entry with = |
| Dates appear as numbers | Wrong number format | Pick a Date format in the Number Format gallery |
Turn off Show Formulas
If every formula on the sheet displays instead of its result, Show Formulas is probably switched on.
- Select the Formulas tab.
- In the Formula Auditing group, select Show Formulas to switch it off.
You can also press Ctrl + ` (the grave accent key) to toggle between formulas and results.
Microsoft notes this setting affects the whole sheet, so it is the first thing to check when many cells look wrong.
Fix a cell formatted as Text
A formula typed into a cell formatted as Text is stored as plain text and never calculates.
- Right-click the cell and select Format Cells > General, or press Ctrl + 1.
- Press F2 to edit the cell.
- Press Enter.
Changing the format alone is not enough, which is why the F2 and Enter step matters.
Fix a large range formatted as Text
Editing cells one by one is slow when a whole column is affected.
- Select the range.
- Apply the number format you want.
- Go to Data > Text to Columns, then select Finish.
Microsoft lists this as the way to convert a large range in one go.
Check the cells your formula refers to
A formula can also fail because the cells it points at are formatted as Text.
- Select the referenced cell.
- On the Home tab, expand the Number group, or press Ctrl + 1, and select General.
- Press F2, then Enter.
Repeat for any other referenced cells that hold numbers stored as text.
Start the formula with an equal sign
An entry without a leading equal sign is not calculated.
Typing SUM(A1:A10) shows that text, while typing =SUM(A1:A10) returns a result.
Check the first character of the cell before trying anything more involved.
Switch calculation back to Automatic
Microsoft states that formulas will not calculate if manual calculation is enabled.
- Select File > Options > Formulas.
- Under Calculation options, set Workbook Calculation to Automatic.
- Select OK.
You can also use the Formulas tab, open Calculation Options in the Calculation group, and choose Automatic.
| Calculation mode | When Excel recalculates |
|---|---|
| Automatic (default) | After every change to a value, formula or name |
| Automatic except data tables | On any change, but data tables only when changed directly |
| Manual | Only when you trigger it, such as with F9 |
Recalculate right now
If you need a fresh result while still in Manual mode, use one of these shortcuts.
| Shortcut | What it does |
|---|---|
| F9 | Recalculates changed formulas and their dependents in all open workbooks |
| Shift + F9 | Does the same for the active worksheet only |
| Ctrl + Alt + F9 | Recalculates all formulas in all open workbooks, changed or not |
| Ctrl + Shift + Alt + F9 | Checks dependent formulas, then recalculates all formulas in all open workbooks |
The Formulas tab also has Calculate Now for all open worksheets and Calculate Sheet for the active one.
Why Excel switched to Manual by itself
Microsoft explains that all open workbooks share one calculation mode.
The first workbook you open sets the mode, and any workbook opened afterward uses that same mode.
So opening a Manual workbook first can switch every other file you open that session to Manual.
Changing the mode in any open workbook changes it for all of them.
Microsoft’s workarounds are to close other workbooks before opening one that needs a different mode, or to set the open workbook to the mode you want first.
What happens to the mode when you save
Excel saves whatever mode is active at that moment, not the mode the file was originally in.
Microsoft’s example is opening an Automatic workbook first and a Manual one second, then saving the Manual file, which immediately saves it as Automatic.
That is why a workbook can quietly change behavior after being opened alongside another file.
| Situation | Mode Excel uses |
|---|---|
| Several workbooks open at once | The mode of the first workbook opened |
| New blank workbook after closing everything | The mode of the documents you just closed |
| New workbook from a template | The mode specified in the template |
| Workbook saved in an earlier Excel version | Fully recalculated on open, unless the mode is Manual |
Choosing Manual also turns on Recalculate workbook before saving, which you can clear if saving becomes slow.
If the formula bar is empty instead
A different problem is a formula that is hidden from the formula bar.
That happens when the cells have Hidden checked on the Protection tab and the sheet is protected.
- Select Review > Unprotect Sheet.
- If Unprotect Sheet is unavailable, turn off the Shared Workbook feature first.
- Right-click the cells, select Format Cells, and clear Hidden on the Protection tab.
Related Excel guides
If Excel itself is misbehaving, try repairing Microsoft 365 apps on Windows 11.
Lost work is covered in how to recover an unsaved Excel workbook.
For a workbook you cannot edit, see how to fix Excel file locked for editing.