Excel Cell Shows Formula Instead of Result? How to Fix It

Errors & fixes · Updated November 19, 2026

If an Excel cell shows a formula instead of its result, first check whether Formulas > Formula Auditing > Show Formulas is turned on; click it to switch back to calculated results. If only one cell is affected, change its number format from Text to General, then re-enter the formula so Excel evaluates it.

Why Excel displays a formula

Excel normally evaluates an entry that begins with an equals sign and displays the result in the cell. For example, a cell containing =2+3 displays 5, while the formula bar shows the formula when that cell is selected. If the grid itself displays =2+3, Excel is either in a mode that reveals formulas or it has treated the entry as text rather than as a formula.

The distinction matters because the same visible symptom can have different causes. A workbook-wide display setting affects many cells at once. Text formatting or an extra character usually affects an individual cell or a range. A formula that calculates but returns an unexpected value is a separate issue: in that case, Excel is evaluating the expression, just not producing the result you expected.

  • Many formula cells show their expressions: check Show Formulas first.
  • One or a few cells show expressions: check the cell format, a leading apostrophe, or spaces before the equals sign.
  • The cell shows a value, but it is wrong or out of date: check the formula itself and calculation settings.

Turn off Show Formulas

Show Formulas is a worksheet display option. When it is enabled, Excel displays formulas in cells instead of their calculated values. It can make columns look wider because formulas often take up more space than results. The setting is useful for reviewing or auditing a worksheet, but it can be confusing if it was enabled accidentally.

  1. Open the affected worksheet and select the Formulas tab.
  2. In the Formula Auditing group, select Show Formulas to turn the display off.
  3. Check whether the cells now show their results.

In Excel for Microsoft 365 on Windows, Ctrl+` (the grave-accent key, often sharing a key with the tilde) toggles Show Formulas. Press it once and check the sheet. Keyboard layouts differ, so the ribbon command is a reliable alternative. On a Mac, use Formulas > Show Formulas; the keyboard shortcut can vary with the keyboard layout and Excel version. In Excel for the web, look for Show Formulas on the Formulas tab if the command is available in the current ribbon layout.

The setting is associated with the worksheet view, so a workbook can appear normal on one sheet and show formulas on another. Check each affected sheet rather than assuming one toggle changed every sheet. Turning off the display does not change formulas or their results; it changes only what the grid displays.

Check the cell format if only some cells are affected

A cell formatted as Text tells Excel to preserve entries as text. If you set a cell to Text before entering a formula, typing =A1+B1 stores those characters rather than calculating the addition. The cell can therefore display the formula exactly as typed even when Show Formulas is off.

To correct an existing formula stored as text in Excel for Microsoft 365 on Windows:

  1. Select the affected cell or range.
  2. On the Home tab, open the Number Format list and choose General.
  3. Select the cell, press F2 to edit it, then press Enter to make Excel interpret the entry again.

Changing Text to General alone may not convert an existing text entry. Re-entering it is the important step: it prompts Excel to parse the contents as a formula. You can also click in the formula bar, make no changes, and press Enter. On a Mac, use the number-format list on the Home tab, then edit the cell and confirm the entry; keyboard behavior can depend on the Mac’s function-key settings.

For future formulas, set the cell to General before typing the formula. If you deliberately need to store a formula-looking string as text—for example, in a lesson or documentation table—Text format is appropriate. You can also begin the entry with an apostrophe, such as '=A1+B1; Excel treats it as text, and the apostrophe is generally not displayed in the cell itself.

Look for an apostrophe, spaces, or missing equals sign

Excel needs to recognize an entry as a formula. A leading apostrophe forces text, and a space before the equals sign can prevent Excel from interpreting the entry as a formula. For instance, =A1+B1 begins with a space, not an equals sign. Remove unintended characters at the start, then confirm the entry again.

Also check that the formula begins with an equals sign. Typing SUM(A1:A3) without the equals sign normally leaves the text in the cell instead of calculating a sum. The formula bar is helpful here: select the cell and inspect its contents. If you see an apostrophe or an unexpected space before the equals sign, correct it there or edit the cell directly.

Some entries are intentionally stored as text, such as product codes, labels, or examples of formulas. Do not convert those indiscriminately. If a range contains a mixture of intended text and calculations, correct only the cells that should calculate.

Separate displayed formulas from calculation problems

Calculation mode is often blamed when a result looks wrong, but it usually does not make a formula appear as text. If calculation is set to Manual, Excel may keep showing an older calculated value until formulas are recalculated. That is different from seeing the formula characters in the cell.

If the cell displays a number or other result that seems stale, check Formulas > Calculation Options > Automatic. Selecting Automatic allows Excel to recalculate formulas when their inputs change. To request a recalculation immediately, press F9 on Windows. On a Mac, use the Formulas tab or the available recalculation shortcut for that Excel version and keyboard; shortcut behavior can differ.

Calculation settings are relevant when results do not update, not as the first fix when a cell literally displays something like =SUM(A1:A3). Likewise, a formula error such as #VALUE! means Excel evaluated a formula but encountered a problem with its inputs or operations. It is not the same symptom as a formula stored as text.

Use a small test to identify the cause

A quick comparison can distinguish a sheet-wide display setting from a cell-specific problem. Select an empty cell that is formatted as General and enter a simple test. With no particular layout needed, enter =2+3; the expected result is 5. If that cell also displays the formula, check Show Formulas. If it displays 5 while an existing cell still shows its expression, inspect that existing cell’s format and characters.

For a worksheet example, suppose A1 contains 10, A2 contains 15, and A3 contains 5. With those values in A1:A3, enter =SUM(A1:A3) in A4. The expected result is 30. If A4 shows the formula text, check the display setting and A4’s format. If it shows 30, Excel is evaluating the formula correctly.

When the issue appears after copying data from another program, consider how the data was imported. A pasted column may have inherited Text formatting, and a CSV file can contain characters that Excel interprets as text. The safest correction is to inspect a few representative cells, confirm which entries should be formulas, and convert only those entries. Avoid applying a broad conversion to a column if it contains identifiers or other text that must remain unchanged.

What changes on Mac and in Excel for the web

The main diagnosis is the same across Excel platforms: check the formula-display option first, then check whether the affected entry is text. In Windows desktop Excel, the ribbon path for the display toggle is Formulas > Formula Auditing > Show Formulas. Ribbon group placement or available commands can vary slightly by window size or product version, so the Formulas tab is the most useful place to start.

On a Mac, use the Formulas tab to locate Show Formulas and the Home tab’s number-format list to change Text to General. If a shortcut does not work, use the ribbon command rather than guessing at a key combination; Mac keyboards and Excel versions do not always map the Windows shortcut directly.

Excel for the web has a more compact ribbon, and the exact visibility of commands can depend on the current interface. Look on the Formulas tab for Show Formulas. The same core checks still apply: if one entry is text, set its format to General and edit or re-enter it. If a command is not available in the browser interface, opening the workbook in desktop Excel gives access to the full Windows or Mac ribbon.

Prevent the problem in future worksheets

A few habits reduce the chance of accidentally storing formulas as text:

  • Keep calculation cells in General or an appropriate numeric format, rather than formatting them as Text before entering formulas.
  • When pasting or importing data, inspect a sample of cells before filling formulas down a large range.
  • Use Show Formulas intentionally for review, and turn it off when finished if you want to see results again.
  • Preserve text values that should not calculate, such as codes or written examples, instead of converting an entire mixed range.

If a workbook is shared, remember that a visible formula may reflect a worksheet display choice rather than a change to the workbook’s calculations. Before editing formulas, check whether other formula cells show their expressions too. That simple check can prevent unnecessary changes to a correct workbook.

Frequently Asked Questions

Why does Excel show the formula in one cell but calculate other formulas?
That pattern usually points to a cell-specific cause: the affected cell may be formatted as Text, begin with an apostrophe, or contain a space before the equals sign. Set the cell to General, remove unintended characters, and re-enter the formula.

Will changing Text to General fix a formula immediately?
Not always. Changing the format changes how Excel treats future entries, but an existing formula-like entry may remain text. After choosing General, edit the cell and confirm it with Enter so Excel parses it again.

Why do formulas show in every cell on a worksheet?
Show Formulas is likely enabled for that sheet. Turn it off from the Formulas tab. On Windows, Ctrl+` also toggles the setting on common keyboard layouts.

Does Manual calculation make Excel display formulas?
No. Manual calculation can leave a result out of date because Excel has not recalculated it, but it does not normally replace the result with formula text. Check the cell format and Show Formulas separately.

Why is there an apostrophe before my formula?
A leading apostrophe tells Excel to store the entry as text. It is useful when you want to show formula characters without calculating them. Remove it only if the cell is meant to contain a working formula, then re-enter the formula.

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.