Excel Showing Formula Instead of Result? How to Fix It

If Excel is showing a formula instead of its result, the cell is usually formatted as text, formula display is turned on, or the entry lacks the expected formula syntax.

These checks help identify the cause and restore calculated values without changing unrelated cells.

Check whether Excel is displaying formulas across the worksheet

If many cells show formulas at once, Excel may have its Show Formulas setting enabled.

This view displays formulas in their cells instead of their calculated results, which can make columns look wider and values disappear from view.

• Open the Formulas tab and check whether Show Formulas is enabled.
  
  Select it to switch back to results.
• Use the keyboard shortcut Ctrl+` (the grave accent key, often beside 1) to toggle formula display.
  
  On some keyboards, you may need to press Ctrl+Shift+`.

This setting affects how formulas appear on screen, not the underlying calculations.

If only one or two cells show formulas, check their contents and number format next.

Change cells formatted as Text to General

A cell formatted as Text treats entries such as =SUM(A1:A3) as literal text.

Changing the number format afterward does not always make Excel reinterpret a formula that was already entered.

You must re-enter it.

1. Select the affected cell or range.
2. On the Home tab, open the Number Format list and choose General.
3. Click the formula bar or press F2, then press Enter to commit the formula again.

For example, if C2 contains =A2+B2, and A2 contains 4 while B2 contains 6, re-entering the formula in a General-formatted cell should display 10.

Remove a leading apostrophe or space

An apostrophe at the beginning of an entry tells Excel to store the rest as text.

For instance, '=A1+B1 displays as text rather than calculating.

A leading space before the equals sign can also prevent Excel from recognizing the entry as a formula.

Select the cell and inspect the formula bar.

If the entry begins with an apostrophe or an unintended space, remove it and press Enter.

Do not remove apostrophes that are part of intentional text, such as a label or an identifier with leading zeros.

Confirm the formula starts with an equals sign

Excel formulas normally begin with =.

An entry such as SUM(A1:A3) without the equals sign is text, not a formula.

Edit it to =SUM(A1:A3) and press Enter.

Also check that the equals sign is the first character.

Text pasted from a website or document may contain a nonbreaking space or a typographic character that looks like a regular one.

If the formula still displays after removing visible spaces and confirming the first character, try typing it directly into the formula bar.

Set calculation to Automatic

Calculation mode controls when Excel updates formula results.

If calculation is set to Manual, formulas can show old values after their inputs change.

This typically causes stale results rather than displaying formula text, but it is a useful check when fixing a worksheet.

1. Go to the Formulas tab.
2. Select Calculation Options, then choose Automatic.
3. Press F9 to recalculate open workbooks, or Ctrl+Alt+F9 to force a full recalculation.

In Excel for the web, recalculation is generally automatic, though a workbook’s settings and formula compatibility can affect what you see.

In older desktop versions, menus may be arranged differently, but the calculation option is still found on the Formulas tab.

Check whether the formula is inside a quoted string

A formula can intentionally return text that looks like a formula.

For example, ="=A1+B1" returns the characters =A1+B1; the quotation marks make that expression text.

Remove the quotation marks around the formula if you want a calculation: =A1+B1.

Functions such as FORMULATEXT also return a formula as text by design.

In Microsoft 365 and Excel 2013 or later, =FORMULATEXT(A1) displays the formula stored in A1.

If you expected a numeric value, check whether a formula-text function or text-building expression was used.

Use Find and Replace carefully for many affected cells

If numerous cells were entered while formatted as Text, select only the intended formula range, change its format to General, then use a controlled re-entry method such as selecting a cell, pressing F2, and pressing Enter. For large ranges, use an appropriate import or conversion workflow and confirm the results on a small selection first.

Before using this method, save a copy of the workbook and check the selection.

Find and Replace may affect formula text within cells, so a broad selection can alter entries you did not intend to change.

For a small number of cells, using F2 followed by Enter is easier to control.

When formulas still appear as text

If the steps above do not solve the problem, check these less common cases:

• The cell is part of an imported data range: Text import settings may have assigned a text type.
  
  Change the column format and re-enter or transform the values.
• The formula uses a function unavailable in your Excel version: Unsupported functions usually produce an error such as #NAME?, rather than showing the formula itself.
  
  Update Excel or replace the unsupported function if needed.
• The workbook is protected: Protection may prevent editing a cell.
  
  Check the Review tab and ask the workbook owner for access if the sheet is locked.
• The entry is in a text editor or preview: Some import, preview, or formula-bar views show stored content rather than the worksheet’s calculated display.
  
  Open the workbook in Excel and inspect the cell there.

For Google Sheets, the same basic checks apply: turn off View > Show formulas, change the cell format from Plain text to Automatic or Number, then edit and re-enter the formula.

Excel-specific keyboard shortcuts and menu names may differ in Sheets.