Excel Formula Not Working? Fix Cells Showing Formulas

Errors & fixes · Updated November 20, 2026

If Excel shows the formula itself instead of its result, first turn off Formulas > Formula Auditing > Show Formulas, then check that the cell is formatted as General rather than Text. If the cell still displays the formula, re-enter it; if it displays an old answer, check calculation mode and recalculate.

First identify what Excel is showing

“The formula is not working” can describe two different problems. In one, a cell visibly contains something like an equals sign followed by a calculation, but Excel does not evaluate it. In the other, Excel returns a value, but that value is wrong or has not updated. The first problem is usually about display settings, cell formatting, or how the formula was entered. The second is more often about calculation settings, references, or the data being used.

Click the cell and look at the formula bar above the worksheet. If the cell displays a formula and the formula bar shows the same text, Excel may be treating the entry as text or displaying formulas across the sheet. If the cell shows a number but the formula bar contains a formula, the formula is being calculated; investigate the result or recalculation instead. This simple check helps avoid changing a correct formula when the real issue is just its display.

Turn off Show Formulas

Excel has a worksheet view that replaces calculated results with the formulas in the cells. It is useful for auditing a workbook, but it can make every formula look broken. On Windows, press Ctrl+` (the grave-accent key, usually near the upper-left corner of the keyboard) to toggle the view. You can also select Formulas > Formula Auditing > Show Formulas on the ribbon. When the setting is off, formula cells display their results again.

If only one cell shows a formula while the surrounding formulas show results, Show Formulas is unlikely to be the cause: the view applies to the worksheet, not just one selected cell. On a Mac, the shortcut can depend on the keyboard layout; use the Show Formulas command in the Formulas tab if the key combination is inconvenient. In Excel for the web, look for Show Formulas on the Formulas tab; the ribbon layout can vary with window size.

Show Formulas also widens columns in some cases so longer formulas can be read. That visual change is another clue that the view may be active. Turning it off does not alter or delete the formulas; it switches the worksheet back to showing calculated values.

Check whether the cell is formatted as Text

A cell formatted as Text before you type an entry will generally keep the entry as text. That means Excel can display an equals sign and formula characters literally instead of calculating them. Select the affected cell and check Home > Number Format. If it says Text, change it to General, then make Excel read the entry again.

Changing the format alone often does not convert an existing text entry into a working formula. After setting General, click in the formula bar or press F2, then press Enter. For several affected cells, select them, change their format to General, and re-enter each entry. If the entries are in a contiguous column, you can also use Data > Text to Columns and finish the wizard without changing the default settings; this can make Excel reinterpret text entries, but check the results before relying on it.

A leading apostrophe can produce the same appearance. Excel uses an apostrophe to store an entry as text, and the apostrophe may not appear in the cell itself. Click the cell and inspect the formula bar: an apostrophe immediately before the equals sign is a useful clue. Remove it, ensure the cell is General, and confirm the entry again. Do not remove apostrophes indiscriminately from a column, since they may intentionally preserve codes such as numbers with leading zeros.

Make sure the formula is entered as a formula

A normal Excel formula begins with an equals sign. If you accidentally type a space or other character before it, or paste it with an apostrophe, Excel may treat the whole entry as text. Check the beginning of the entry in the formula bar and remove anything unintended before the equals sign. Also check that the formula is complete: an unfinished expression or a missing closing parenthesis usually produces an error or an editing prompt rather than a calculated result.

For a basic example, with numbers in A1 and B1, enter =A1+B1 in C1. If A1 contains 4 and B1 contains 6, C1 should show 10. If the formula is visibly printed in C1, test the cell format and Show Formulas setting rather than changing the arithmetic. If Excel reports an error, inspect the references and syntax instead.

Formula argument separators can vary with regional settings. Many installations use commas between function arguments, while some use semicolons. If a formula copied from a website is rejected, Excel may expect the other separator for your locale. Use the separator Excel accepts in that installation; do not confuse this with a formula being displayed as text, which is a separate issue.

Check calculation mode and recalculate

If Excel displays a result that seems stale, the workbook may be using manual calculation. Select Formulas > Calculation Options > Automatic to make Excel recalculate formulas when their inputs change. In manual mode, a formula can be valid and present while its displayed answer remains unchanged until calculation is requested.

On Windows, press F9 to calculate formulas in open workbooks. Ctrl+Alt+F9 forces a full calculation, including formulas Excel might otherwise consider unchanged. On a Mac, use the calculation commands on the Formulas tab if Windows shortcuts do not apply; keyboard shortcuts can vary by keyboard and Excel version. Recalculation can take time in a large workbook, so save first if the file is complex.

Calculation mode can be affected by workbooks opened in the same Excel session, and a workbook may have been saved while calculation was set to manual. If a workbook repeatedly opens with stale results, check Calculation Options rather than assuming each formula needs to be rewritten. Automatic calculation can also make large models slower, so some users deliberately choose manual mode; in that case, recalculate when inputs change and verify that the displayed results are current.

Separate display issues from formula errors

If Excel shows an error such as #NAME? or #VALUE! rather than the formula text, it is evaluating the entry. The error message points toward a different investigation: check spelling of function names, the kind of value supplied, and whether references contain the expected data. A formula that returns zero may also be calculating correctly if its referenced cells are blank or contain values that do not meet the formula’s conditions.

For a simple addition example, with values in A1 and B1, the formula =A1+B1 in C1 returns 10 when A1 is 4 and B1 is 6. If A1 or B1 contains text that cannot be used as a number, the result may differ or produce an error. Check the source cells directly, including spaces and imported data that looks numeric but is stored as text. Formatting a result cell as a date, percentage, or currency can also change how a value looks without changing the underlying calculation.

Another common misconception is that pressing Enter always forces Excel to calculate. Enter confirms the cell entry, but it will not fix a Text-formatted cell, turn off Show Formulas, or change manual calculation mode. Match the fix to the symptom: literal formula text, stale result, and error value are not interchangeable problems.

A reliable troubleshooting order

Work through these checks in order, changing one thing at a time. That makes it easier to see which setting caused the problem and avoids altering a workbook unnecessarily.

  1. Click the cell and compare its displayed contents with the formula bar. Decide whether Excel is showing literal text, an old result, or an error.
  2. If many formulas are visible, toggle Show Formulas off using the Formulas tab or the Windows shortcut.
  3. If only one entry is literal, check its number format and look for a leading apostrophe or space.
  4. Set a text-formatted formula cell to General, then press F2 and Enter to re-enter it.
  5. If a value is stale, check that Calculation Options is set to Automatic, or recalculate if manual mode is intentional.
  6. If an error remains, verify the formula’s references, separators, function spelling, and the contents of the referenced cells.

After fixing a cell, test it with a simple, known input before copying the change across a large range. For example, if a formula is intended to add two cells, use small values whose total is easy to verify. When correcting many formulas, keep a copy of the original workbook or use Undo promptly if the result is not what you expected.

Frequently Asked Questions

Why does Excel show the formula instead of the answer?
Most often, Show Formulas is on, or the cell is formatted as Text. If all formulas on the sheet are visible, turn off Show Formulas. If just one cell is affected, set it to General and re-enter the formula.

Why does changing the cell to General not fix it?
Excel may have already stored the entry as text. After changing the format, edit the cell and confirm it again, such as by pressing F2 and then Enter. Formatting changes alone do not always reinterpret an existing entry.

Why does my formula show an old answer?
Check Formulas > Calculation Options. If calculation is Manual, switch to Automatic or request a recalculation. Also verify that the cells used by the formula actually changed and that the formula refers to the intended cells.

Why does only one cell show a formula?
Show Formulas normally affects the worksheet, so a single affected cell points more strongly to Text formatting, a leading apostrophe, or an extra character before the equals sign. Inspect the formula bar and re-enter the cell after correcting the cause.

Does pressing F9 fix a formula that is displayed as text?
No. F9 recalculates formulas; it does not convert text into a formula or change the Show Formulas view. Fix the entry or display setting first, then use recalculation only if the result is stale.

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.