Excel Shows the Formula Instead of the Result — Fix It

If every formula on the sheet is showing as text, press Ctrl+` — the grave accent key, above Tab, sharing with the tilde. That's Show Formulas, and it's on.

If only some cells are affected, it's a different problem with a different fix, and the rest of this guide is about those.

Three cells that never computed anything, and one that did. The only difference is what was in the cell before the formula went in.

Which problem do you have?

Symptom	Cause
The whole sheet, and the columns went wider	Show Formulas is on
One cell or column, text sitting to the left	The cell holds text, not a formula
Some sheets affected, others not	Show Formulas — it's a per-sheet setting

The widened columns are the giveaway for Show Formulas. Excel widens them to fit the formula text, and narrows them again when you turn it off.

⚠️ Show Formulas is saved with the file and set per sheet, not per workbook. A colleague can send you a file already in that state, on one tab only, and nothing about it looks like a setting — it looks like the file is broken.

When it's one cell: is it actually text?

=ISTEXT(A2)

TRUE means the cell holds characters, not a formula. Excel never computed anything, because as far as it's concerned you typed a sentence.

The quicker version of the same test: real formulas produce numbers, and numbers sit to the right of the cell. Text sits left. A column of formulas where one is left-aligned tells you which one.

Cause 1: the cell was formatted as Text

The most common of the three, and the one with the trap in it.

Changing the format to General does not fix it. The cell already contains the characters =A1+B1, and reformatting only changes how that string would display. It still displays as itself.

The cell has to be re-entered:

1. Set the cell (or column) to General.
2. Press F2, then Enter.

F2 puts the cell into edit mode; Enter commits it, and now that the format is General, Excel reads the leading = and treats it as a formula.

Same principle as codes turning into dates — format first, enter second. Formatting is never retroactive.

Cause 2: something before the equals sign

A single space, or an apostrophe:

 =A1+B1      a space — invisible
'=A1+B1      an apostrophe — invisible in the cell,
             visible in the formula bar

Both make the entry text. Both are invisible in the cell itself.

=LEN(A2) identifies the space — a formula one character longer than an identical-looking one beside it. For the apostrophe, click the cell and read the formula bar, where it does show.

These usually arrive by paste, from an email or a text editor or a web page.

Cause 3: no equals sign at all

SUM(A1:A10) is a piece of text that happens to look like a function. Obvious once you're looking for it, invisible when you're not, and common in a column where every other row is correct.

Fixing a whole column at once

Two ways, both fast. Both need the format set to General first — while the cells are still formatted as Text, neither does anything.

Find and Replace with itself

1. Select the range.
2. Ctrl+H
3. Find what: =   Replace with: =
4. Replace All

Replacing every equals sign with an equals sign changes nothing about the content — and forces Excel to re-enter every cell it touches, which is the whole point. Anything that was a formula waiting to be recognised now is one.

It also handles the leading-space case if you search for = (space, equals) and replace with =.

Text to Columns

Select the column, then Data → Text to Columns → Finish. It re-parses every cell in place, converting text formulas to real ones on the way.

Works on a single column at a time, which is its only limitation against Find and Replace.

Stopping it happening

• Don't format columns as Text pre-emptively. Only the ones that genuinely hold codes. A column formatted Text "just in case" is where this problem lives.
• Paste with Ctrl+Shift+V (values only) when bringing text in from elsewhere, so formatting doesn't travel with it.
• Check the format before typing into an unfamiliar sheet. The Number Format box on the Home tab tells you in a glance.

Does this work in Google Sheets?

Yes, with a different shortcut for the view setting: Ctrl+` works, and it's also under View → Show → Formulas.

Sheets has Format → Number → Plain text in place of Excel's Text format, and the same rule applies — set it before entry, and re-enter the cell to undo the effect.

ISTEXT and LEN behave identically.

When it goes wrong

Ctrl+` does nothing

Wrong key — it's the grave accent above Tab, not the apostrophe next to Enter. Some keyboard layouts put it elsewhere; use Formulas → Show Formulas instead.

I set it to General and it still shows the formula

Formatting isn't retroactive. Press F2 then Enter, or use one of the bulk fixes.

Find and Replace says it made replacements but nothing changed

The cells are still formatted as Text. Set to General first, then run it again.

It only happens in one column

That column is formatted as Text. Check the Number Format box with a cell selected.

New rows keep coming out as text

The formatting is on the whole column, so anything typed into it inherits the problem. Reformat the column, not just the affected cells.

Common questions

Why does Excel even have Show Formulas?

It's genuinely useful for auditing — you can see every formula at once and spot the one cell where someone typed a number over the top. Ctrl+` is worth knowing deliberately, not just as something to switch off.

Can I print the formulas?

Yes — turn Show Formulas on and print normally. That's a reasonable way to review a complicated sheet away from the screen.

How do I show a formula on purpose, as text?

Either the leading apostrophe, or =FORMULATEXT(A1), which displays another cell's formula as text while that cell keeps working. The second is better for documentation, since it updates if the formula changes.

Everything shows the formula and Show Formulas is off

The cells really are text. Check ISTEXT. If a whole sheet is affected, someone formatted every column as Text, or the file came out of a system that exported it that way.

The short version

• Whole sheet, wider columns: Ctrl+`. It's a per-sheet setting and it saves with the file.
• Individual cells: =ISTEXT(), or look at which side of the cell the content sits.
• Text formatting, a leading space, a leading apostrophe, or a missing =.
• Reformatting alone never fixes it. The cell must be re-entered.
• Bulk fix: set to General, then Find and Replace = with =.
• Don't format columns as Text unless they hold codes.

Next steps: the format-before-you-type rule is the same one that governs codes turning into dates, and text where a number should be is one of the five causes of #N/A. If a whole imported file arrived this way, fixing types is step three of cleaning it.