Excel Showing Formulas Instead of Results? Fix It

Errors & fixes · Updated November 19, 2026

If Excel shows formulas in cells instead of their calculated results, first turn off Formulas > Show Formulas. If only certain cells are affected, change their number format from Text to General, then re-enter each formula; if formulas calculate but their results are stale, set calculation to Automatic under Formulas > Calculation Options.

These symptoms can look alike, but they have different causes. The checks below help distinguish a worksheet-wide display setting from text-formatted cells, manual calculation, and results that are hidden or otherwise unexpected.

First determine whether one cell or the whole sheet is affected

Look at the worksheet before changing anything. If many cells that contain formulas display strings such as =SUM(B2:B6), and the columns may have become wider to accommodate them, Excel may be displaying formulas across the worksheet. If just one or a few cells show formula text while neighboring formulas display numbers, suspect those cells’ formats or how their contents were entered.

Also distinguish what appears in the cell from what appears in the formula bar. Selecting a normal calculated cell usually shows its formula in the formula bar while the cell itself shows the result. Seeing the formula in the formula bar is expected; seeing it in the grid is the issue. If the grid shows a result but the formula bar shows no leading equals sign, the cell may contain text rather than a working formula.

Turn off Show Formulas

In Excel for Microsoft 365 on Windows, open the Formulas tab and select Show Formulas to switch back to results. The setting applies to the worksheet, so it can make every formula visible at once. It does not change or remove the formulas; it changes how Excel displays them.

On Windows, Ctrl+` (Control plus the grave-accent key, commonly below Esc) toggles Show Formulas. Keyboard layouts differ, so the ribbon command is the dependable alternative if the shortcut does not work. In Excel for Mac, use Formulas > Show Formulas; the shortcut can vary with the keyboard layout and macOS settings. In Excel for the web, look for the Show Formulas command on the Formulas tab if it is available in your interface.

If only one sheet appears affected, switch Show Formulas off while that worksheet is active. It is easy to mistake this view for a calculation failure because formulas remain visible even when calculation is set to Automatic. Conversely, changing calculation settings will not turn this display mode off.

Change cells formatted as Text

Excel generally treats an entry made in a cell formatted as Text as text, not as a formula to evaluate. This often happens when someone formats a column before pasting data, imports content from another system, or copies cells from a text file. The formula can look perfectly normal while remaining inert.

  1. Select the affected cells.
  2. On the Home tab, open the Number Format list and choose General.
  3. With a cell layout of a value in A1 and another value in B1, the intended addition formula is =A1+B1. After changing the cell to General, activate each affected formula cell and press F2, then Enter, to make Excel parse its contents again.

Changing the format alone may not be enough: Excel does not always reinterpret text already in the cell just because its format changes. Re-entering the content after switching to General is the important step. For a small number of cells, F2 and Enter is straightforward. For a large imported range, make a copy first and test a few cells before choosing a bulk conversion method, since import cleanup can also change dates, identifiers, and leading zeros.

On Mac, the same principle applies: set the cells to General using the Home tab’s number-format controls, then edit and confirm the affected entries. The key used to edit a cell may differ by keyboard configuration; double-clicking the cell or editing in the formula bar is another way to re-enter it.

Check for a leading apostrophe or space

A leading apostrophe tells Excel to store an entry as text. A formula-like string entered that way will display literally rather than calculate. Leading spaces can cause a similar problem because the first character Excel sees is not the equals sign. This may happen when copying from a web page, email, or text export. Click the cell and inspect the beginning of its contents in the formula bar; remove any unintended apostrophe or spaces, then confirm the entry again.

For a formula to be interpreted as a formula, it normally needs to begin with an equals sign and use valid Excel syntax. With the numbers 4 in A1 and 7 in B1, the cell layout assumed here is A1 and B1 as those inputs; entering =A1+B1 in another cell returns 11. If that same expression is stored as text, Excel does not perform the addition. This is why a formula that looks correct is not proof that Excel has recognized it as a formula.

Set workbook calculation to Automatic

Manual calculation is a different issue: Excel recognizes formulas but may leave their displayed results unchanged until calculation is requested. In Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options > Automatic. The calculation mode can affect more than one workbook open in the same Excel session, so a workbook may seem to inherit an unexpected setting after another file was opened.

After selecting Automatic, give Excel a moment to recalculate. You can also press F9 to calculate open workbooks. Shift+F9 calculates the active worksheet. Laptop function-key settings may require holding Fn, and Mac keyboards or system settings can change how function keys behave; use the Calculation Options menu when a shortcut is uncertain. If formulas are visibly printed in cells, however, return to Show Formulas and cell-format checks: manual calculation does not normally cause formulas to appear as text.

Manual mode can be useful in very large workbooks where recalculating after every edit is slow, but it can make figures look out of date. Before sharing a workbook, set the intended calculation mode and recalculate so recipients are less likely to see old results.

Check whether the result is present but hidden

Sometimes Excel is calculating, but formatting makes the result look missing. A custom number format can hide values, font color can match the cell background, or a formula can intentionally return an empty string. A narrow column usually displays a row of number signs for a number rather than the formula itself; widen the column to see whether that is the problem. These cases call for checking formatting or the formula’s logic, not changing calculation mode.

For instance, a formula may return a blank when its input is blank, even though the formula is working normally. If a cell displays nothing, select it and inspect the formula bar, then check the formula’s inputs and number format. If you see an error such as #VALUE! or #NAME?, Excel is evaluating the formula but has encountered a separate problem; an error is not the same as a formula displayed literally.

Verify the formula and its inputs

Once Excel is evaluating the entry, check that it refers to the intended cells and that those cells contain the expected values. A simple test can confirm whether a formula is working. With 10, 12, 8, 15, and 5 in B2:B6, the assumed layout is those five values in that range; enter =SUM(B2:B6) in another cell and the result should be 50. If the result differs, check for text values, blank cells, or an unintended range rather than assuming the display setting is still responsible.

Function names and argument separators can depend on Excel’s language and regional settings. Many installations use commas between function arguments, while some locales use semicolons. If Excel rejects a formula as invalid, consult the function’s syntax in your installed Excel or use the separator expected by that installation. A syntax error usually produces an error or a formula-entry warning; it is distinct from a valid formula being displayed as text.

Prevent the same problem in imported or shared files

Before pasting or importing a column of formulas, check whether the destination cells are set to General rather than Text. When bringing in data from a CSV or another application, inspect a few rows after import: dates, codes with leading zeros, and formula-like strings can all be interpreted differently from their source. Keep an untouched copy of important source data until the imported workbook has been checked.

  • Use General for cells that should contain formulas, and use Text only when you deliberately want Excel to preserve an entry literally.
  • After pasting formulas, check both a sample cell in the grid and the formula bar.
  • Before troubleshooting stale results, confirm Formulas > Calculation Options > Automatic.
  • When a whole sheet suddenly displays formulas, check Formulas > Show Formulas before editing the cells.

These checks also help when a workbook is shared between Windows, Mac, and Excel for the web. The core distinction remains the same across platforms: a display setting shows recognized formulas, text formatting prevents formula evaluation, and manual calculation delays updates. The exact shortcut or location of a command may differ, so use the ribbon or menu when a keyboard shortcut is unreliable.

Frequently Asked Questions

Why is Excel showing formulas in every cell?

Show Formulas is likely enabled for that worksheet. Turn it off under Formulas > Show Formulas. The formulas are not being replaced; Excel is displaying them instead of their results.

Why does only one cell show the formula?

That cell may be formatted as Text, or its content may start with an apostrophe or space. Set it to General, remove any unintended characters at the beginning, then edit and confirm the entry again.

Why is Excel not updating a formula result?

Check Formulas > Calculation Options and select Automatic. If the formula is already in Automatic mode, press F9 to recalculate and check whether the formula refers to the correct inputs.

Does changing Text to General fix the formula immediately?

Not necessarily. Changing the format does not always make Excel reinterpret existing text. After selecting General, edit the cell with F2 and press Enter, or otherwise re-enter the formula.

Why do I see a formula in the formula bar but a number in the cell?

That is normal. The formula bar shows the selected cell’s underlying formula, while the worksheet grid ordinarily shows its calculated result. It is only a display problem if the formula itself appears in the grid when you expect a 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.