Excel Cell Shows Formula Not Result? Fix It Fast

Errors & fixes · Updated November 22, 2026

If your Excel cell shows the formula text instead of the calculated result, the most likely cause is that the cell is formatted as Text, or the “Show Formulas” mode is turned on. Press Ctrl + ` (the backtick key, usually above Tab) to toggle Show Formulas off, and if that doesn’t work, check the cell’s number format and change it from Text to General, then re-enter the formula.

Why Excel Displays the Formula Instead of the Result

Excel is designed to show either the formula or its result, and three main settings control which one you see. The first is Show Formulas, a workbook-level view that displays every formula in the sheet as text. The second is the cell’s number format set to Text, which forces Excel to treat the formula as a literal string. The third is a missing or misplaced equal sign (=) — if the formula doesn’t start with =, Excel sees it as plain text. There is also a fourth, less common cause: the cell might contain a leading apostrophe (‘) before the equal sign, which tells Excel to treat the entire entry as text.

Quick Fixes to Try First

  1. Press Ctrl + ` (Windows) or Control + ` (Mac) to toggle Show Formulas off. This is the fastest fix and works for the entire worksheet.
  2. Check the formula bar — if it shows the formula but the cell shows the result, the cell is fine; if both show the formula, the issue is global.
  3. Look at the cell’s number format: select the cell, go to Home > Number group, and if the dropdown shows “Text,” change it to “General.” Then click into the formula bar and press Enter to re-evaluate.
  4. If the formula has an apostrophe before the = (like '=A1+B1), delete the apostrophe from the formula bar and press Enter.

How Show Formulas Mode Works

Show Formulas is a view toggle, not a cell property. When enabled, every cell that contains a formula displays its formula text instead of the calculated value. This is useful for auditing a spreadsheet, but it can confuse users who accidentally press Ctrl + ` while reaching for the Esc key. The toggle is also available on the ribbon: Formulas > Formula Auditing > Show Formulas. On a Mac, the shortcut is Control + ` (the same backtick key). If you’re using Excel for the web, you can’t use the keyboard shortcut — go to View > Show Formulas in the ribbon instead.

Why Text-Formatted Cells Break Formulas

When you set a cell’s number format to Text before typing a formula, Excel treats the entry as a string. For example, if you type =A1+B1 into a Text-formatted cell, Excel stores it as the literal characters “=A1+B1” and never calculates it. The cell displays exactly what you typed. This often happens when you import data from a CSV file or when you apply Text formatting to a column before entering formulas. To fix it, change the format to General, then re-enter the formula by clicking in the formula bar and pressing Enter. Note: changing the format does not automatically recalculate the cell — you must re-enter the formula or press F2 then Enter.

How to Prevent This in the Future

  • Avoid setting entire columns to Text format unless you’re entering phone numbers, ZIP codes, or other identifiers that shouldn’t be numeric.
  • When importing CSV files, use Data > From Text/CSV and choose the correct data types in the import wizard instead of letting Excel guess.
  • If you copy formulas from a web page or another application, paste them using Home > Paste > Paste Special > Values first, then re-type the formula if needed.
  • Check the formula bar regularly — if you see a leading apostrophe, remove it immediately.

Common Misconception: It’s a Calculation Setting

Many users assume the problem is that Excel’s calculation mode is set to Manual. That’s a different issue: in Manual mode, the cell shows the old result (or a blank if never calculated), but it still shows a number, not the formula text. If your cell shows the formula text, calculation mode is irrelevant. However, if you change a cell’s format from Text to General and the result doesn’t appear, press F9 (Windows) or Command + = (Mac) to force a full recalculation. Manual mode is found under Formulas > Calculation Options, and it’s rarely the cause of formulas displaying as text.

Frequently Asked Questions

Why does my formula show as text after I press Ctrl+Z?

Undo can restore a cell’s formatting along with its content. If you had accidentally set the cell to Text format, then typed a formula, then pressed Ctrl+Z, Excel might revert the format to Text again. Check the number format and re-enter the formula.

Can I make all formulas show as text permanently?

Yes, but it’s not recommended. You can turn on Show Formulas (Ctrl+`) to view all formulas, or you can format cells as Text and type formulas without the equal sign (like A1+B1) to store them as literal text. Neither is a good practice for a working spreadsheet.

Why does one cell show the formula but the rest of the column works fine?

That single cell likely has a Text format or a leading apostrophe. Select the cell, change the format to General, then click in the formula bar and press Enter. If it still doesn’t work, check for a space before the equal sign.

Does this happen in Google Sheets too?

Yes, Google Sheets has a similar issue: if the cell is formatted as Plain Text, formulas will display as text. The fix is to change the format to Automatic or Number, then re-enter the formula. The Show Formulas toggle in Google Sheets is under View > Show formulas (shortcut: Ctrl+` on Windows, Command+` on Mac).

How do I check if a cell is formatted as Text without changing it?

Select the cell, then look at the Number Format dropdown in the Home tab. If it says “Text,” that’s the problem. You can also press Ctrl+1 to open Format Cells and look at the Category list under the Number tab.

When to Use Show Formulas vs. Formatting as Text

Show Formulas is a temporary view for auditing — you can toggle it on, check your work, and toggle it off. Formatting cells as Text is a permanent data-entry choice, best reserved for columns that contain non-numeric data like part numbers or codes. If you need to document a formula for a colleague, consider using a comment (right-click > Insert Comment) or a separate cell with the formula as text (preceded by an apostrophe) rather than changing the original cell’s format.

Final Checklist for Stubborn Formula Display Issues

  • Is Show Formulas on? Press Ctrl + `.
  • Is the cell format Text? Change to General and re-enter.
  • Is there an apostrophe or space before =? Remove it.
  • Is the formula missing an equal sign? Add it.
  • Did you use a semicolon instead of a comma in the formula? In some European locales, Excel uses semicolons as argument separators, but the formula bar will show a comma in English versions — check your regional settings.

If none of these work, try copying the formula into a blank cell and see if it calculates there. If it does, the original cell has a formatting issue. If it doesn’t, the formula itself has an error (like a missing parenthesis or a reference to a deleted sheet). In that case, Excel would normally show a #REF! or #NAME? error, not the formula text, so a formula that displays as text almost always points to formatting or the Show Formulas toggle.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.