When an Excel formula shows as plain text instead of the answer, Excel is usually doing exactly what one setting or format told it to do. The fix is to find whether the sheet is showing formulas, the cell is formatted as text, or the entry is not a real formula yet. Start with the fastest checks, then use the range fixes if a whole column is affected.
Turn Off Show Formulas
This fixes a worksheet where formulas appear in cells instead of calculated results.
Select Formulas.
Select Show Formulas to switch the worksheet back to displaying results.
Press Ctrl + ` on Windows for the same toggle.
Press Ctrl + ` on Mac if you are using Excel for Mac.
Change Text Cells Back to General
Use this when one formula, or a small group of formulas, still sits there as text after Show Formulas is off. Excel can keep a formula as text when the cell was formatted as Text before the formula was entered.
Right-click the cell that shows the formula.
Select Format Cells.
Choose General.
Press F2.
Press Enter so Excel re-enters and evaluates the formula.
Check the Worksheet Display Option
Excel for Windows also has a worksheet-level display setting that can force formulas to show instead of calculated results. Open File, select Options, then choose Advanced.
Under Display options for this worksheet, clear Show formulas in cells instead of their calculated results. Check the worksheet named in that dropdown before closing the dialog.
Return to the workbook and confirm the cells now show results. If only a few formulas still appear as text, change those cells to General, then use F2 and Enter.
Remove Characters Before the Equal Sign
Select the cell that is showing the formula as text.
Press F2 to edit it.
Delete the apostrophe before the formula if the formula came from a pasted example.
Delete any space or other character before =.
Press Enter.
Tip: a working formula such as =SUM(A1:A10) starts with = as the first character.
Fix a Whole Column at Once
When many formula-like entries were stored as text, clean up the range in one pass.
- 1.Select the affected range.
- 2.Apply the number format you want, such as General.
- 3.Open Data and select Text to Columns.
- 4.Select Finish.
- 5.Check a few cells to confirm Excel now shows calculated results.
Set Calculation Back to Automatic
Calculation mode is a different problem from formulas stored as text. It fixes formulas that were entered correctly but stopped updating.
In Excel for Windows, open File, select Options, choose Formulas, then set Workbook Calculation to Automatic under Calculation options. You can also select Formulas, choose Calculation Options, then select Automatic.
In Excel for the web, select Formulas, choose Calculation Options, then select Automatic. In Excel for Mac, open the Excel menu, select Preferences, choose Calculation, then select Automatic.
For a manual refresh in Excel for Windows, press F9 to recalculate changed formulas in all open workbooks, Shift + F9 for the active worksheet, Ctrl + Alt + F9 for all formulas, or Ctrl + Shift + Alt + F9 to check dependent formulas and recalculate all formulas.
Convert Numbers Stored as Text
Use this when formulas calculate incorrectly because the values they reference are stored as text. This cleans up numeric inputs, not every formula string that appears as plain text.
Select the cells you want to convert.
Select the error indicator in the top-left corner of the cell, or press Alt + Shift + F10.
Select Convert to Number.
If the alert button is missing in Excel for Windows, open File, select Options, choose Formulas, then turn on Enable background error checking under Error Checking.
Start With an Equal Sign
This fixes entries that look like formulas but were typed as ordinary text.
Edit the cell that is not calculating.
Make = the first character.
Type the formula in normal Excel form, such as =SUM(A1:A10).
Press Enter.
Handle Work Managed Excel Settings
The most common cause is a local workbook setting, cell format, or entry problem.
Try the workbook fixes first: turn off Show Formulas, change text-formatted cells to General, remove characters before =, and set calculation to Automatic only when formulas stop updating.
When Excel keeps reverting or a setting is locked, contact your workplace Microsoft 365 admin. Microsoft documents Cloud Policy for Microsoft 365 as an admin-controlled policy surface for supported Office settings across managed devices.
Paste Special with Multiply is still available in current desktop Excel, but it is an optional method for numeric values stored as text, not a fix for a formula string that sits in the cell as text. For this problem, use Text to Columns, Convert to Number, or the VALUE workflow when numbers are stored as text.
Frequently Asked Questions
Why is my Excel formula showing instead of the result?
The usual causes are Show Formulas being turned on, the cell being formatted as Text, an apostrophe or space before the equal sign, or the formula not starting with =.
Why does changing the cell format not fix it immediately?
Changing Text format to General does not always re-evaluate the existing entry by itself. After changing the format, press F2, then press Enter.
Does Automatic calculation fix formulas showing as text?
No. Automatic calculation fixes formulas that already calculate but do not update. It does not turn a text-stored formula into a working formula.
How do I fix many formulas showing as text at once?
Select the affected range, apply the format you want, then use Data > Text to Columns > Finish. For numeric values stored as text, use the Convert to Number error menu.