Why Your Excel Formula Is Not Calculating

Work through them in that order. The first two are settings that affect the whole workbook, so ruling them out first saves you inspecting individual cells that were never the problem.

1. Show Formulas is switched on

The giveaway: every formula in the sheet displays as text, columns look unusually wide, and nothing shows a result. Nothing is broken — this is a display mode, usually triggered by hitting Ctrl + ` by accident while reaching for Ctrl + 1.

Press Ctrl + ` again to toggle it off, or use Formulas → Formula Auditing → Show Formulas. The wide columns revert on their own.

2. Calculation is set to Manual

Here the formulas show results, but the results are stale — you change an input and nothing downstream moves.

Excel offers manual calculation so that very large workbooks stay usable, and the setting is documented under formula recalculation options. The trap is that it is a per-session, first-workbook-wins setting.

To fix it: Formulas → Calculation Options → Automatic. To force an immediate recalculation, F9 recalculates changed cells, and Ctrl + Alt + Shift + F9 rebuilds everything.

3. The cell was formatted as Text

This affects one cell or one column rather than the sheet. The formula sits there as literal text, and — the reliable tell — it is left-aligned, because Excel aligns text left and numbers right by default.

The cause is order of operations: the cell was formatted as Text before the formula was typed. Excel took the entry literally. Changing the format afterwards does not fix it, because the cell already holds text — which is the part that confuses people.

The fix, in order:

1. Select the cells and set Home → Number Format to General.
2. Re-enter each formula: press F2 then Enter. This is the step people skip, and without it nothing changes.

For a whole column, re-entering one at a time is impractical. Use Data → Text to Columns, click Finish immediately — it re-parses every selected cell with the current format and converts them in one pass.

4. A leading space or apostrophe

A formula typed as =A1+B1 with a space before the equals sign is text, because Excel only treats an entry as a formula when = is the very first character.

A leading apostrophe does the same thing deliberately — '=A1+B1 tells Excel to store the entry as text. The apostrophe does not appear in the cell, only in the formula bar, so it is easy to miss. Both usually arrive via a paste from a web page or another application.

Delete the space or apostrophe and press Enter.

5. A circular reference

A formula that refers to its own cell, directly or through a chain. Excel cannot resolve it, so it returns 0 and shows Circular References in the status bar along the bottom.

Formulas → Error Checking → Circular References lists the offending cells. The usual cause is a SUM that includes its own cell — =SUM(A1:A10) sitting in A10 rather than A11.

Quick diagnosis table

What you see	Cause	Fix
All formulas show as text, wide columns	Show Formulas is on	Ctrl + `
Results shown but never update	Manual calculation	F9, then set to Automatic
One formula as text, left-aligned	Cell formatted as Text	Set to General, then F2 + Enter
Formula as text, nothing obviously wrong	Leading space or apostrophe	Delete it, press Enter
Returns 0, status bar warning	Circular reference	Error Checking → Circular References
Returns an error code instead	A different problem	See Excel formula errors explained

If the problem is specific to SUM — a total of zero, or one that is simply too low — why your Excel SUM is not working covers why SUM ignores text without warning, and when to use SUBTOTAL instead.

Frequently asked questions

Why is my Excel formula not calculating?

Usually one of four things: Show Formulas is toggled on, calculation is set to Manual, the cell was formatted as Text before the formula was entered, or there is a circular reference. Check in that order — the first two affect the whole workbook.

Why does Excel show my formula instead of the result?

If every formula does it, Show Formulas is on — press Ctrl + `. If only one does and it is left-aligned in its cell, that cell was formatted as Text before you typed the formula.

Why doesn't my Excel formula update when I change a value?

Calculation is set to Manual. Press F9 to recalculate now, then set Formulas → Calculation Options → Automatic. If it reverts, a workbook you open regularly was saved with Manual and is imposing it on the session.

I changed the format from Text to General and it still shows the formula

Changing the format does not convert existing content — the cell still holds text. You must re-enter the formula: press F2 then Enter. For a whole column, select it and use Data → Text to Columns → Finish.

Why does my formula return 0?

Most often a circular reference — check the status bar and Formulas → Error Checking → Circular References. It can also happen when the values being summed are text that looks numeric, in which case SUM ignores them.

What is Ctrl + ` in Excel?

It toggles Show Formulas, displaying every formula as text instead of its result. The key is the grave accent above Tab, next to 1. It is a common accidental press when reaching for Ctrl + 1.

Does this apply to Google Sheets?

Partly. Sheets has the same Show Formulas toggle and the same text-format trap, but no Manual calculation mode — see Google Sheets formulas not updating for what differs.

Conclusion

Check the two workbook-wide settings first: Show Formulas, then calculation mode. Between them they explain most cases, and both are one keystroke to rule out.

If it is only one cell, look at the alignment. Left-aligned means Excel is holding text, and the fix is always the same — set the format to General, then re-enter the formula so Excel parses it again.

Related: Excel formula errors explained covers what each error code means, and VLOOKUP and XLOOKUP covers lookup formulas specifically.