Home › Excel

Excel Formula Showing as Text Instead of a Result

Short answer: If Excel displays your formula instead of calculating it, the cell is formatted as text or Show Formulas is turned on.

TL;DR: quick fix

Press Ctrl+` (grave accent) to toggle Show Formulas off, or go to Formulas > Show Formulas.
Right-click the cell > Format Cells (Ctrl+1) > General, then press F2 and Enter.
Make sure the formula starts with = and has no space or apostrophe before it.

Is Excel down?

Before you change settings, check Microsoft 365 Service health. If there's an outage, wait it out.

How to fix it: step by step

Press Ctrl+` (grave accent) to toggle Show Formulas off, or go to Formulas > Show Formulas.
Right-click the cell > Format Cells (Ctrl+1) > General, then press F2 and Enter. For a whole column, apply a number format then use Data > Text to Columns > Finish.
Make sure the formula starts with = and has no space or apostrophe before it.
Check Formulas > Calculation Options is set to Automatic.

FAQ

Why do my formulas not update?

Calculation may be set to Manual. Set it to Automatic or press F9 to recalculate.

More Excel fixes

Excel Not Responding: How to Fix Freezes

Last checked Oct 2026 against the official help page: Microsoft Support. Menus can differ by app version; follow the official page if a step doesn't match.