Excel Cell Showing Formula Instead of Value? Fix It

Errors & fixes · Updated November 19, 2026

If an Excel cell shows a formula instead of its result, first turn off Formulas > Formula Auditing > Show Formulas; on Windows, Ctrl+` also toggles that view. If only one or a few cells are affected, they may be formatted as Text or contain a leading apostrophe, so change the format to General and re-enter the formula.

Why Excel shows formulas instead of results

Excel normally calculates a formula and displays its result in the cell, while the formula itself appears in the formula bar when that cell is selected. For example, a cell might display 20 even though its formula adds two other cells. When the formula itself appears in the grid, the cause is usually a display setting or a cell-entry issue, rather than a problem with the calculation.

The first clue is how widespread the symptom is. If many formula cells across a worksheet show their formulas, Show Formulas is the likely cause. If one cell or a small group shows formula text while neighboring formulas show results, check the affected cells’ number format and contents. A workbook can contain both situations, so test the display setting first, then investigate individual cells that remain unchanged.

It also helps to distinguish a formula from a formula result. A result can be a number, text, a date, or an error such as #VALUE!. Those are outputs from Excel. The literal expression beginning with an equals sign is the formula itself. A displayed formula is not the same as a formula error: errors show that Excel evaluated an expression but could not produce the expected result.

Turn off Show Formulas

In Excel for Microsoft 365 on Windows, go to Formulas > Formula Auditing > Show Formulas. If the option is active, selecting it turns the worksheet back to displaying calculated results. The Windows keyboard shortcut Ctrl+` toggles the same view. The backtick key is commonly near the upper-left corner of the keyboard, but its location and the keystroke needed to type it can vary by keyboard layout.

On a Mac, use Formulas > Show Formulas if the command is available on the ribbon. The shortcut may differ with the keyboard layout; on many Mac keyboards, Control+` toggles formula display. If that shortcut does not work, use the ribbon command instead. In Excel for the web, look for Formulas > Show Formulas; the available ribbon layout can vary with the browser window size.

Show Formulas is a worksheet display option, not a change to the formulas themselves. Switching it off does not delete or rewrite formulas. It also explains why a whole sheet may suddenly look different after a keystroke: the shortcut can be pressed accidentally, especially when the backtick key is near a frequently used key. Check the command’s state rather than editing each displayed formula one by one.

Check whether the cell is formatted as Text

When just one or a few cells show formulas, the cells may have been set to the Text number format before the formula was typed or pasted. In that format, Excel treats an entry such as a formula as text instead of calculating it. Changing the format afterward does not necessarily convert the existing text into a working formula; you usually need to make Excel parse the entry again.

  1. Select the affected cell or cells.
  2. On the Home tab, open the Number Format list and choose General.
  3. Select a cell and press F2, then press Enter. This re-enters the contents so Excel can interpret them as a formula.
  4. Check that the cell now displays a result and that the formula bar still shows the expression.

For a small number of cells, re-entering the formula is the clearest fix. For a larger range of text-formatted entries, you can test Data > Text to Columns on a copy of the data, leaving the default Delimited choice and selecting Finish. This can make Excel reinterpret text entries, including formula-like entries, but it may also affect other values in the selected range. Review the result before applying it to important data.

Look for a leading apostrophe or space

An apostrophe typed before an entry tells Excel to treat the entry as text. It is often used to preserve leading zeros in codes, but it can also prevent a formula from calculating. A leading space before the equals sign can have a similar effect because the entry no longer begins with a formula marker. Select the cell and inspect the formula bar: look for an apostrophe or blank space before the equals sign.

Remove the extra character, make sure the cell uses General or another suitable non-Text format, and press Enter to commit the corrected entry. If the formula was pasted from a website, email, or text file, check for invisible or unusual characters as well. Pasted content can include formatting or characters that are not obvious in the grid. Re-entering the expression directly in the formula bar can help establish whether the pasted content is the problem.

Also check that the entry actually starts with an equals sign. An expression typed without one is ordinary text, not a formula. For example, if A1 contains 12 and B1 contains 8, enter =A1+B1 in C1; Excel calculates and displays 20. If C1 instead displays the characters of the expression, check Show Formulas, the cell format, and any characters before the equals sign.

Distinguish formula display from calculation problems

Calculation settings can cause results to be stale, but they do not normally make a cell display its formula. If the cell displays a number that does not update after a referenced value changes, check whether calculation is set to Manual. In desktop Excel for Windows, use Formulas > Calculation Options > Automatic. Excel for Mac has a Calculation Options command on the Formulas tab as well. Excel for the web generally calculates automatically and does not provide the same desktop calculation-mode controls.

With Manual calculation enabled, Excel may keep showing an older result until a calculation is triggered. Pressing F9 recalculates open workbooks in Windows Excel; Shift+F9 recalculates the active worksheet. Mac keyboards and function-key settings can change how those shortcuts work, so the Formulas ribbon is a useful alternative. These recalculation commands address outdated results, not a cell that literally displays formula characters.

Other issues have different signs. A formula error such as #NAME? or #DIV/0! means Excel attempted to calculate something and returned an error. A cell showing ###### usually means the column is too narrow for a numeric or date value, not that formula display is turned on. A formula visible only in the formula bar is normal; what matters is whether the cell grid shows the expression or its calculated result.

Repair several affected cells safely

If a whole worksheet shows expressions, toggle Show Formulas off before making bulk edits. If only a range is affected, select a small sample first and confirm that the entries are genuinely formulas stored as text. This prevents a broad repair from changing labels, identifiers, or other text that happens to begin with punctuation.

  • Only one cell: Set it to General, remove any leading apostrophe or space, then press F2 and Enter.
  • A contiguous range: Test the Text to Columns method on a duplicate or a small sample, then inspect formulas and values before applying it to the remaining range.
  • Mixed data: Avoid converting the entire column without checking it. Text identifiers such as 00123 are often intentionally stored as text, and conversion could change how they are represented.
  • Unexpected changes: Use Undo immediately if the result is wrong, or close without saving if you have not made other changes you need to keep.

Before repairing a large or business-critical workbook, save a separate copy. After the repair, spot-check several cells: confirm that expected results appear, select those cells to verify formulas remain in the formula bar, and check that totals or dependent calculations still make sense. A visual fix is not enough if a conversion has altered underlying data.

Show formulas deliberately for auditing

Displaying formulas can be useful when reviewing a model, checking references, or documenting how a worksheet is built. The same Show Formulas command makes expressions visible in the grid, which can make a sheet easier to inspect than selecting cells one at a time. Turn it off again when you want the ordinary results view. The command changes what the worksheet displays; it does not protect formulas or hide them from people who can inspect the workbook.

If you need a formula’s text in a separate cell while keeping its result visible in the original cell, Excel also has the FORMULATEXT function. With a formula in A1, enter =FORMULATEXT(A1) in B1; B1 returns the formula text from A1. This is different from Show Formulas because the text is returned as the value of another cell, while A1 continues to show its calculated result. FORMULATEXT requires a reference to a cell containing a formula.

Frequently Asked Questions

Why are all my Excel formulas showing instead of results?
Show Formulas is likely enabled for that worksheet. Turn it off from Formulas > Formula Auditing > Show Formulas, or use Ctrl+` in Windows Excel.

Why does only one Excel cell show the formula?
The cell may be formatted as Text, or the entry may start with an apostrophe or a space. Set the cell to General, remove unwanted characters, and re-enter the formula.

Will changing Text to General fix a formula immediately?
Not always. If the formula was already entered as text, changing the format alone may leave it as text. Press F2 and Enter to re-enter it, or test a suitable conversion method on a copy of the data.

Why does Excel show an old answer instead of updating?
The workbook may be using Manual calculation, or the formula may not depend on the cell you changed. In desktop Excel, check Formulas > Calculation Options > Automatic and recalculate if needed.

Why does the formula bar show a formula when the cell shows a number?
That is normal. The formula bar displays the selected cell’s underlying formula, while the grid normally displays its calculated result. Show Formulas changes the grid display.

Can I display formulas without changing the result cell?
Yes. Turn on Show Formulas for the worksheet, or use FORMULATEXT in another cell to return the formula as text while the original cell continues to display its result.

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.