Excel Formulas Not Calculating or Showing as Text Instead of the Result

Q: Show Formulas is on — every cell shows its formula.

That's a different toggle: press Ctrl + (the grave accent, left of 1) or click Formulas > Show Formulas to turn it off. This affects the whole sheet, not one cell.

Q: The number format already says General but it still shows the formula.

Re-enter the formula with F2 then Enter. A format change doesn't retroactively recalculate; the cell has to be re-evaluated.

Published ✓ Verified ⏱️ 3 min read October 15, 2025 · by Ryan Bennett

You type =A1+B1 and the cell shows the literal text =A1+B1 instead of a result. Or your formulas were working, then stopped updating when you changed the inputs.

Why: Two unrelated settings cause almost every case. (1) The workbook is in Manual calculation mode, so Excel waits for you to press F9 instead of recalculating on every change. (2) The cell is formatted as Text, so Excel treats your formula as a string of characters, not a calculation — it shows the formula text and never computes it.

Fix 1: Switch calculation back to Automatic

If results are stale or only update when you re-enter a formula, calculation is set to Manual.

Go to the Formulas tab.
Click Calculation Options (far right of the ribbon).
Select Automatic.

Alternatively: File > Options > Formulas, and under Calculation options > Workbook Calculation, choose Automatic, then OK. To force an immediate recalc of everything, press Ctrl + Alt + F9.

Watch out: calculation mode is a per-session setting that the first workbook you open imposes on the rest. If a colleague sends a file saved in Manual mode, it can flip your Excel to Manual for every file until you change it back.

Fix 2: Change the cell from Text to a number format

If the cell shows the formula text (=A1+B1) instead of computing it, the cell is formatted as Text.

Select the cell(s). On the Home tab, in the Number group, the format dropdown will read Text.
Change it to General (or Number).
Changing the format alone won’t recalculate an existing formula — you must re-enter it. Click the cell, press F2 (edit), then Enter. Excel now evaluates it and shows the result.

Worked example: cell C2 contains =2+3 but displays =2+3. Set C2 to General, press F2 then Enter — it now shows 5. (Tip: format the cell before typing the formula to avoid this entirely.)

Fix 3: Convert text-formatted numbers so they’ll add up

A related symptom: numbers won’t sum because they’re stored as text (often left-aligned, sometimes with a little green triangle in the corner).

Use the error-check button: Select the cell with the green triangle, click the warning button (⚠) that appears, and choose Convert to Number. Select a whole column first to fix many at once.
Apply a number format: Select the range, Home > Number group > Dialog Box Launcher (the small arrow), pick Number, click OK.
Paste Special trick (for stubborn cases): Type 1 in a blank cell and copy it. Select your text-numbers, Home > Paste > Paste Special, choose Multiply, OK. Multiplying by 1 forces them to real numbers. Delete the helper cell after.

If values have stray spaces blocking conversion, clean them first with =TRIM(A1) or =CLEAN(A1).

FAQ

Show Formulas is on — every cell shows its formula. That’s a different toggle: press Ctrl + ` (the grave accent, left of 1) or click Formulas > Show Formulas to turn it off. This affects the whole sheet, not one cell.

Why did my file open in Manual mode? Excel adopts the calculation mode of the first workbook opened in that session. Set it back to Automatic (Fix 1); to make it stick, save the workbook while in Automatic.

The number format already says General but it still shows the formula. Re-enter the formula with F2 then Enter. A format change doesn’t retroactively recalculate; the cell has to be re-evaluated.

Sources: Microsoft Support — Detect formula errors in Excel · Microsoft Support — Fix text-formatted numbers by applying a number format