Excel troubleshooting

Why Does Excel Show the Formula Instead of the Result?

Fix Excel cells that display the formula text instead of the calculated result by checking cell format, show formulas mode, and leading spaces.

Problem

  • Excel displays formula text when the worksheet is in Show Formulas mode, the cell is formatted as Text, or the formula was entered with a leading space.

Quick fix

  • Turn off Show Formulas, set the cell to General format, delete any leading space before the equals sign, and re-enter the formula.

Check these first

  • Press Ctrl+` or use Formulas > Show Formulas to confirm the sheet is not in formula view.
  • Inspect the cell format in the Home tab — Text format prevents calculation.
  • Make sure the formula starts with = and not a space before =.

Best fixes

  • Change format to General, press F2, then Enter.
  • Copy a working formula from another cell and adapt the references.
  • Use Find and Replace to clean accidental leading spaces in a column of formulas.

Frequently asked questions

  • Ctrl+` shows formulas — how do I turn off? Press Ctrl+` again or Formulas → Show Formulas to return to calculated values.
  • Apostrophe before = in CSV imports? Remove leading apostrophe or use Text to Columns on General format, then re-enter the formula.
  • Formula works in one cell but not copied down? Downstream cells may be formatted as Text. Set the column to General and fill down again.