Excel Returns Formula Instead of Value? Fix It

Errors & fixes · Updated November 19, 2026

If Excel displays a formula such as =A2+B2 in the cell instead of its result, first turn off Formulas > Formula Auditing > Show Formulas. If only one cell is affected, change its number format to General, then edit and re-enter the formula; if results are merely stale, set calculation to Automatic.

What it means when Excel shows a formula

A worksheet cell normally shows a formula’s calculated result, while the formula itself remains visible in the formula bar when you select that cell. For example, a cell containing a valid addition formula usually shows a number in the grid, not the characters that make up the formula. When the characters appear in the grid, Excel may be displaying formulas intentionally, or it may have stored the entry as text rather than interpreting it as a formula.

Those are different problems from a formula that calculates to an unexpected answer or displays an error such as #VALUE!. In the first case, the formula is visible as text. In the second, Excel has evaluated the formula but produced an error or an unwanted result. It helps to check whether the problem affects the whole sheet, a few cells, or the calculated result only after identifying the symptom.

For a quick test, select the cell. If the formula bar shows a formula and the cell itself shows the same formula, check Show Formulas and the cell’s format. If the formula bar shows an apostrophe or the entry lacks an initial equals sign, Excel may be treating the content as text.

Turn off Show Formulas for the worksheet

Show Formulas is a worksheet view setting that makes Excel display formulas in cells instead of their calculated results. It is useful when auditing a model or checking which formulas are present, and it can be switched on accidentally. When it is active, many formula cells across the sheet appear to change at once. Columns may also look too narrow because formula strings are longer than their results.

  1. In Excel for Microsoft 365 on Windows, open the Formulas tab.
  2. In the Formula Auditing group, click Show Formulas to turn the display off.
  3. Alternatively, press Ctrl+` (the grave-accent key, often shared with the tilde key) to toggle the view.

On a Mac, use Formulas > Show Formulas if the command is available on the ribbon; the keyboard shortcut can depend on the keyboard layout. In Excel for the web, use the Formulas tab’s Show Formulas command when available. Once the setting is off, formula cells should show their calculated results again. The setting applies to the worksheet, so it is a strong clue when many cells are affected at the same time.

One possible confusion: Excel still shows the underlying formula in the formula bar when you select a normally calculated cell. That is expected and does not mean Show Formulas is on. The setting changes what appears in the worksheet grid.

Fix a cell stored as text

If just one or a few cells show formulas while other formula cells display results, inspect their number format. A cell formatted as Text before a formula is entered can keep an entry such as =A2+B2 as literal text. Changing the format afterward does not necessarily convert the text into a working formula; Excel may need to re-interpret the entry.

  1. Select the affected cell or range.
  2. On the Home tab, open the Number Format list and choose General.
  3. Re-enter the formula: select the cell, press F2, then press Enter. You can also click the formula bar and press Enter.

For this worked example, assume A2 contains 12, B2 contains 8, and C2 is the cell where you enter the addition formula. After setting C2 to General and re-entering it, =A2+B2 calculates to 20. The key step is re-entering the formula after changing the format, not simply choosing General. For a whole column of text-stored formulas, first test the correction on a small selection, then apply the same edit-and-re-enter process to the remaining cells.

Text formatting is often intentional for identifiers such as product codes, account numbers, or values with leading zeroes. Avoid changing an entire column to General without checking what its contents represent. In this situation, fix only the cells intended to calculate formulas.

Check for an apostrophe, spaces, or a missing equals sign

Excel recognizes a formula when the entry begins with an equals sign. Typing a function name without that sign—for example, entering SUM(A1:A3) as plain text—does not ask Excel to calculate it. Correct the entry by adding the equals sign, provided the cell is not deliberately meant to hold text.

A leading apostrophe also tells Excel to keep the following content as text. It may not be prominent in the cell grid, but selecting the cell can reveal it in the formula bar or in the editing line. Remove the apostrophe if the cell should contain a live formula, then confirm the entry. A space before the equals sign can cause a similar issue because the first character is no longer the formula marker. Delete any accidental leading spaces and type the formula again.

Check the entry itself rather than assuming every visible equals sign is active. A value pasted from an email, web page, text file, or another application may include an apostrophe or leading whitespace. If the cells are intended to document formulas as examples, however, keeping them as text is appropriate.

Understand calculation mode and stale results

Calculation mode is a related setting, but it causes a different symptom. In Manual calculation mode, Excel may not update formula results after input cells change. The formula cell generally still displays its last calculated value, not the formula string. This setting matters if the formula is visible and the problem has not been resolved, but it is not usually the reason formulas appear as text.

To check the setting in Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options > Automatic. Calculation settings can affect other open workbooks in the Excel session, so check them if seemingly unrelated files also fail to recalculate. In Excel for Mac, look for Calculation Options on the Formulas tab; exact availability and presentation can vary by version. Excel for the web generally calculates supported formulas automatically, though some features and workbook settings differ from desktop Excel.

If calculation was set to Manual, choose Automatic and allow Excel to recalculate. On Windows, F9 calculates formulas in open workbooks; Shift+F9 calculates the active worksheet. Mac keyboard shortcuts can differ, and some keyboards require the Fn key with function keys. These commands recalculate formulas; they do not turn a text entry into a formula or switch off Show Formulas.

Check what the formula is designed to return

Not every formula returns a number. A formula can legitimately return text, such as a status label, a date formatted as text, or a message selected by a condition. That is different from Excel displaying the formula’s literal characters. If a formula evaluates to the text Complete, seeing that word is the result, not evidence that the formula failed.

Excel also has a function called FORMULATEXT, which deliberately returns a formula as text. For this example, assume C2 contains the formula =A2+B2 and D2 is the cell used to inspect it; =FORMULATEXT(C2) returns the text =A2+B2 in D2. This behavior is useful for documentation or audits. It does not replace the result in C2, and it should not be confused with Show Formulas.

When reviewing an unfamiliar workbook, consider whether the cell is meant to show a formula string for teaching, reporting, or documentation. Also inspect nearby cells and the formula bar: a single cell that returns text may be functioning exactly as designed, while a whole sheet displaying the formulas points more strongly to Show Formulas.

Common troubleshooting mistakes

Changing the column width is not a fix for a formula displayed literally. Wider columns may help when Show Formulas is on, but they do not make a text-stored entry calculate. Likewise, pressing F9 cannot repair a formula that Excel never recognized. Diagnose the entry and display settings before trying to force recalculation.

A practical order of checks is:

  • Many formula cells show formulas: turn off Show Formulas.
  • Only selected cells show formulas: check for Text format, a leading apostrophe, spaces, or a missing equals sign.
  • The cell shows a result, but it does not change: check Calculation Options and recalculate.
  • The cell shows a word or message: determine whether that text is the formula’s intended result.

If a formula still does not calculate after these checks, inspect its references and syntax. A misplaced parenthesis, a reference to the wrong cell, or a function argument issue can cause a formula error, but those problems typically produce an error or an incorrect result rather than displaying the formula itself. Work on a copy if you are making bulk changes to a workbook you cannot easily reconstruct.

Frequently Asked Questions

Why is Excel showing formulas in every cell?
Show Formulas is likely enabled for that worksheet. Go to Formulas > Formula Auditing > Show Formulas and turn it off, or use Ctrl+` on Windows.

Why does only one Excel cell show the formula?
That cell may be formatted as Text or contain a leading apostrophe, a leading space, or no equals sign. Set it to General, remove unintended characters, then edit and re-enter the formula.

Will changing Text format to General fix the formula automatically?
Not always. If Excel already stored the entry as text, change the format and then press F2 followed by Enter to make Excel interpret the entry again.

Why does my formula not update when I change another cell?
That is usually a recalculation issue rather than a display issue. Check Formulas > Calculation Options and select Automatic; a workbook in Manual mode may retain old results until recalculated.

Why does the formula bar show a formula when the cell shows a number?
That is normal. The worksheet cell displays the calculated result, while the formula bar shows the expression stored in the selected cell so you can inspect or edit it.

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.