Formula Errors

How to Fix Excel Displaying Formulas as Text Instead of Calculating

Camila Milosovich Oct 13, 2026 871 views

Question details

The user needs to resolve an issue where Excel displays the formula itself rather than outputting the calculated result.

How to Fix Excel Displaying Formulas as Text Instead of Calculating

Product: Excel
Device & OS: not provided
Scenario: Entering a mathematical calculation or cell reference into a worksheet cell.
Observed behavior: The cell displays the exact typed formula string (e.g., '=A1+B1') instead of showing the calculated numerical or text output.

Before you start

Before troubleshooting individual cells, verify that you have not accidentally toggled the 'Show Formulas' view, which reveals all formulas across the entire worksheet instead of their results.

Solution 1Recommended

Change Cell Formatting to General and Re-enter Formula

The most common reason a formula displays as text is that the cell's number format is explicitly set to 'Text'. Changing it to 'General' allows Excel to process the calculation.

When a cell is formatted as Text, Excel treats everything entered into it as a literal string. To fix this, you must change the formatting and then force Excel to re-evaluate the cell's contents.

Select the affected cell

Click on the cell that is displaying the formula as text.

Change format to General

Go to the 'Home' tab on the Excel ribbon, locate the 'Number' group, click the dropdown menu, and select 'General'.

Re-enter the formula

Double-click the cell or click inside the Formula Bar at the top, then press 'Enter'. This forces Excel to recalculate and display the result.

Change Cell Formatting to General and Re-enter Formula

Quick Recalculation Shortcut: You can also press F2 and then Enter to quickly re-evaluate the formula after changing the cell format to General.

Solution 2

Remove Leading Spaces or Apostrophes

A hidden space or an apostrophe placed before the equals sign (=) forces Excel to treat the entire entry as plain text.

Solution 3

Turn Off the Show Formulas Command

If every single formula in your worksheet is displaying as text simultaneously, the 'Show Formulas' mode is likely active.

Seamless Spreadsheet Calculations

Calculate Formulas Flawlessly with WPS Spreadsheet

WPS Office provides a powerful spreadsheet tool that perfectly handles complex formulas and calculations. Fix cell formatting issues easily and boost your productivity with an interface you already know.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing the formula issues.
2. Select the text-formatted cells: Highlight the cells that are incorrectly displaying the formula text.
3. Change format to General: Navigate to the Home tab and choose 'General' from the Number Format dropdown menu.
4. Re-evaluate the cells: Press F2 on your keyboard and hit Enter to instantly apply the calculation.

100% compatible with Microsoft Excel (.xlsx, .xls) files and formulasIntuitive interface for quickly managing cell formatting and data typesLightweight application with rapid calculation speed for large datasets

microsoft office alternative - wps office

Frequently Asked Questions

How do I fix multiple cells displaying formulas as text at once?

To fix a large range of cells, select all affected cells, change their format to 'General' from the Home tab, then go to the Data tab, click 'Text to Columns', and click 'Finish' immediately. This forces Excel to evaluate all selected cells simultaneously.

Does typing an apostrophe before a formula break it?

Yes. In Excel, typing an apostrophe (') before any data forces the application to treat the contents as literal text, preventing the formula from calculating. Deleting the apostrophe will resolve the issue.

Why does my formula copy as text when I paste it into another cell?

If the destination cell is pre-formatted as 'Text', pasting a formula into it will cause it to display as text. Ensure the destination cell is formatted as 'General' before pasting, or use 'Paste Special' > 'Formulas'.

Excel & Data Problems