Excel Shows the Formula Instead of the Result

When an Excel formula is showing as text, such as =SUM(B2:B6) instead of the total, Excel is treating your formula as words rather than a calculation. The cause is almost always one of four things: Show Formulas is on, the cell is formatted as Text, there is a character before the =, or the = is missing. This guide shows how to tell which one you have and how to fix it in seconds.

Why does Excel show the formula instead of the result?#

Excel only calculates an entry that it reads as a formula. That means the first character must be = and the cell must not be set to store text. If either condition fails, Excel keeps exactly what you typed and shows it in the cell.

Use this quick check to find the cause:

If you are new to formulas, our guide to writing your first Excel formula explains the basic rule: every formula starts with =.

Cause 1: Show Formulas is turned on#

Show Formulas makes every cell on the sheet display its formula instead of its result. It is useful for checking your work, but easy to switch on by accident, because its shortcut is one key away from common keys.

To turn it off:

• Keyboard: press **Ctrl+** on Windows. The key (grave accent) is usually to the left of the 1 key. On a Mac, use Control+` (the Control key, not ⌘).
• Ribbon: go to the Formulas tab and click Show Formulas in the Formula Auditing group, so it is no longer highlighted.

The setting belongs to one sheet. If another sheet in the same workbook looks normal, that confirms Show Formulas is the cause. You will also notice that the columns get wider while it is on, and the results come back as soon as you press the shortcut again.

Cause 2: The cell is formatted as Text#

A cell with the Text number format stores whatever you type as text, even a formula. This often happens when you add formulas to a column of IDs or codes that someone formatted as Text, or when data comes from another system.

To fix it:

1. Select the cells that show formulas.
2. On the Home tab, open the Number Format box and choose General. (You can also press Ctrl+Shift+~ to apply General, which you practise in the More formatting lesson.)
3. Re-enter each formula: click the cell, press F2 and press Enter. On a Mac, press Control+U to edit the cell, or double-click it.

Step 3 is the one people miss. Changing the format does not make Excel re-read the cell. Until you re-enter it, the formula stays text.

Fix many cells at once#

If a whole column shows formulas, re-entering each one by hand is slow. After setting the cells to General, use Find and Replace:

1. Select the cells.
2. Press Ctrl+H (Mac: Control+H) to open Replace.
3. Type = in Find what and = in Replace with.
4. Click Replace All.

Replacing = with itself makes Excel re-enter every cell, so each formula is calculated.

Cause 3: A space or apostrophe before the equals sign#

If a formula starts with a space or an apostrophe, Excel treats the whole entry as text. The cell shows =B3*C3, and the formula bar shows '=B3*C3 or =B3*C3.

This happens when you copy formulas from a web page, an email or a document, which may add a leading space. It also happens when someone types an apostrophe on purpose to show a formula as an example.

To fix it, click the cell, press F2, move to the start of the entry with Home, delete the extra character and press Enter. An apostrophe does not show in the cell itself, so always check the formula bar.

Cause 4: The equals sign is missing or wrong#

Without = at the very start, Excel sees plain text. SUM(B2:B6) is just a label. A formula that starts with a different character, such as + in some older habits, may still work, but a formula typed in quotes, like "=SUM(B2:B6)", is always text.

Check the formula bar. If there is no = at the start, add it and press Enter. If the formula also has a mistake inside, Excel tells you once it tries to calculate it, so fix one problem at a time.

How to check a formula once it calculates#

Once the result appears, make sure it is the right result. A formula can calculate and still be wrong. The usual problems are:

• Order of operations. =B2+B3*2 multiplies first. Use brackets when you mean (B2+B3)*2. Our article on Excel order of operations explains why.
• Numbers stored as text. If a total looks too small, some inputs may be text. See how to find and fix numbers stored as text.
• A result that never changes. If the result is stuck when you change an input, calculation may be set to Manual. Our guide on why an Excel formula is not updating covers that case.

How to stop it happening again#

A few habits prevent most of these problems:

• Format input columns as General or a number format, not Text, unless they really hold text like codes with leading zeros.
• When you copy a formula from a web page, paste it into the formula bar and check the first character.
• If you need to show a formula as an example in a report, use an apostrophe on purpose and add a note, so no one mistakes it for a broken cell.
• Learn the Show Formulas shortcut, so if every cell suddenly shows formulas you know to press Ctrl+` again.

These are quick fixes, and spotting them fast is part of the basic skill set covered in how long it takes to learn Excel for a job.

Practise it#

Try the exercise on this page: one pay formula was typed with an apostrophe, and you re-enter it so it calculates. Then practise writing formulas that start with = in a live spreadsheet, and use the More formatting lesson to reset a cell to General with one shortcut.