Excel Table Showing Formula Not Result? Fix It

Errors & fixes · Updated November 18, 2026

If an Excel table is showing a formula instead of its result, first turn off Formulas > Formula Auditing > Show Formulas, or press Ctrl+` on Windows. If only one or a few cells show formula text, change those cells from Text to General and re-enter the formulas; the table itself does not have a separate setting that replaces results with formulas.

Why a formula appears instead of its result

Excel normally displays a formula’s calculated result in the cell and keeps the formula available in the formula bar when you select that cell. For instance, a cell might show 25 while its formula bar shows how Excel calculated 25. If the cell itself displays something beginning with an equals sign, Excel is either set to show formulas or has stored the entry as text rather than evaluating it.

These two situations look similar but need different fixes. The Show Formulas setting affects the worksheet’s display: formula cells show their expressions instead of their calculated values. By contrast, a text-formatted cell treats an entry such as =A2+B2 as characters. Excel does not calculate it, and changing the cell’s number format afterward does not automatically turn the existing text into a formula.

A third possibility is that the expression is being evaluated correctly but is designed to return text. A formula using a text function, or one that joins words and numbers, can produce a text result. That is different from Excel displaying the formula’s characters without evaluating them.

Check whether Show Formulas is turned on

When Show Formulas is active, Excel displays formulas across the current worksheet instead of their results. It is a worksheet display option, not an error in the table or its formulas. Column widths may also expand to make the expressions easier to read, so the sheet can look noticeably different.

  1. Open the Formulas tab.
  2. In Formula Auditing, select Show Formulas to turn the display off.
  3. Alternatively, press Ctrl+` on Windows. The grave accent is commonly on the key beneath Esc, though its location depends on the keyboard layout.

On a Mac, use the Formulas tab and its Show Formulas control if the keyboard shortcut differs for your keyboard layout. If you select a cell and its formula appears in the formula bar but its calculated value appears in the grid, that is normal; the formula bar is meant to show the cell’s contents.

After you turn the option off, check whether the affected table cells show results again. If other formula cells on the worksheet also displayed their expressions, that is a strong sign Show Formulas was the cause. If just one table column or a handful of cells remain unchanged, investigate their formatting and contents instead.

Tell formula display from text stored in a cell

Select one affected cell and inspect both the cell and the formula bar. If the grid shows the formula and the formula bar shows the same expression, check Show Formulas first. If the grid shows the formula but the entry is left-aligned, has a leading apostrophe, or behaves like ordinary text when edited, the cell may contain text. Alignment alone is not proof, because users can apply custom alignment.

A leading apostrophe is often used to force an entry to be treated as text. Excel may hide the apostrophe in the grid while showing it in the formula bar. A space before the equals sign can also stop Excel from recognizing an entry as a formula. For example, an entry that begins with a space followed by = is not the same as one that begins with =.

Another useful check is to select an unaffected cell in the same table column. If it displays a result while the affected cell displays formula text, a worksheet-wide Show Formulas setting is less likely to be the explanation. Compare the cells’ number formats and their actual entries. A copied cell may have brought a Text format or apostrophe into the table even if the surrounding cells are General or Currency.

Fix cells that are formatted as Text

For a small number of cells, changing the number format and re-entering each formula is usually the clearest repair:

  1. Select the affected table cells.
  2. On the Home tab, open the Number Format list and choose General.
  3. Select a cell, press F2 to edit it, then press Enter. Repeat for each affected formula cell. This makes Excel interpret the existing entry again.

On a Mac, the function-key behavior can depend on your keyboard settings; you may need to use Fn+F2 to edit the selected cell. You can also click in the formula bar, make a minor edit such as removing and retyping the equals sign, and press Return. The important part is to make Excel parse the entry again after changing the format. Merely choosing General is not enough for a formula that Excel has already stored as text.

If the formula bar reveals a leading apostrophe or a space before the equals sign, remove that extra character and press Enter. Check the formula carefully before confirming it. If the entry is still not recognized, clear the cell and type or paste the intended formula again after setting the cell to General.

For a large range, do not assume a format change alone will repair every cell. Test the process on one cell first, confirm that its result is correct, then apply the same edit-and-confirm action to the remaining affected cells. If the formulas were imported from a text file or copied from another program, inspect a few entries for leading apostrophes, spaces, or other characters before deciding how to repair the full range.

How formulas work inside Excel tables

An Excel table is a structured range with features such as filter buttons, a header row, and the ability to extend as new rows are added. A formula entered into a table column often becomes a calculated column: Excel fills the formula down that column and may extend it to new table rows. These conveniences do not change the basic rule that Excel must recognize a cell’s entry as a formula before it can calculate it.

For example, suppose a table has headers Quantity, Unit Price, and Total, and one row contains a quantity of 3 and a unit price of 12.50. With those exact headers in an Excel table, the formula for the Total column can be written as:

With Quantity in the table’s Quantity column and the per-item amount in its Unit Price column, enter this formula in the same row of Total:

=[@Quantity]*[@[Unit Price]]

The result for that row is 37.5, which can display as $37.50 if the Total column uses a currency format. The bracketed references are structured references: they identify values in the current table row by column name. If Excel fills the formula down, each row uses its own Quantity and Unit Price values.

If a table column has a mix of results and visible formula text, look for a cell-specific cause such as Text formatting or an apostrophe. If the whole worksheet shows formulas, use the worksheet display control instead. Also note that a table may not fill a formula down if its calculated-column behavior has been changed or disabled; that affects automatic filling, not whether a correctly entered formula can calculate in an individual cell.

Check calculation settings if results seem stale

Manual calculation is a related issue, but it usually causes an old result to remain visible rather than making the formula appear in the cell. To check the setting in Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options and select Automatic. With manual calculation, Excel may wait to recalculate formulas until you request it.

Use Formulas > Calculate Now to recalculate the open workbook, or press F9 when you are not editing a cell. If formulas show their expressions rather than results, however, recalculation is not the first fix: turn off Show Formulas or correct cells stored as text. Recalculating does not convert text into a formula.

If a formula does return an unexpected value, check its references and inputs as well as calculation mode. A table formula can be valid but refer to the wrong column, or a referenced cell may contain text where a number was expected. Those are formula or data problems, not the same as Excel displaying the expression itself.

A practical troubleshooting order

Use this order to avoid changing working formulas unnecessarily:

  • Look at the whole worksheet. If many formula cells display expressions, switch off Show Formulas.
  • Compare neighboring cells. If only a few cells in one table column are affected, inspect their formats and contents.
  • Check the entry. Look for Text formatting, an apostrophe, or a space before the equals sign.
  • Re-enter one formula. Set its cell to General, edit the entry, and press Enter. Confirm that the result is correct before applying the repair elsewhere.
  • Check calculation mode last. Use Automatic or Calculate Now if results are stale, but do not expect recalculation to fix text entries.

This order separates a display option from a cell-content problem and a calculation problem. It also helps protect unrelated table data: changing the number format for an entire table column might affect dates, percentages, or currency values that were intentionally formatted differently.

Prevent the problem in new table rows

Before entering or pasting formulas into a table, check that the destination cells are not formatted as Text. If formulas arrive from a website, text file, or another application, paste a small sample first and verify that Excel evaluates it. When copying a formula column, compare the new entries with a known-good row and make sure no apostrophe or leading space was included.

For a calculated column, enter a valid formula in a table row and check whether Excel fills it down as expected. If it does not, verify that the cells are inside the table and that automatic calculated-column filling has not been disabled. You can still enter the formula into the appropriate table cells manually. Turning Show Formulas on can be useful when auditing a workbook, but turn it off again when you want to review the calculated results.

Keep the distinction in mind: number formatting controls how a calculated value looks, while Show Formulas controls whether Excel displays expressions or results on the worksheet. Neither setting changes what a formula means. Text formatting can stop Excel from evaluating a newly entered formula, which is why re-entering the cell contents is part of that repair.

Frequently Asked Questions

Why is only one cell in my Excel table showing a formula?
If other formulas display results, check that cell for Text formatting, a leading apostrophe, or a space before the equals sign. Set it to General and re-enter the formula.

Why are all the formulas showing instead of the results?
Show Formulas is probably enabled for the worksheet. Select Formulas > Formula Auditing > Show Formulas to turn it off, or press Ctrl+` on Windows.

Will changing the cell from Text to General fix the formula?
Not by itself in every case. After choosing General, edit the cell and press Enter so Excel parses the existing entry again. Otherwise, clear and re-enter the formula.

Does an Excel table calculate formulas differently from a normal range?
Tables add features such as structured references and calculated-column filling. A formula still needs to be entered as a formula, and the table has no separate setting that makes formulas display instead of results.

Why does my formula show an old answer instead of updating?
Check Formulas > Calculation Options and select Automatic, then use Formulas > Calculate Now if needed. An old value points to a calculation issue; visible formula text usually points to Show Formulas or text storage.

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.