Formula Errors

Fix Excel Formulas Displaying as Text on Mac

Nimra MalikNimra Malik Nov 20, 2026 869 views

Question details

Excel formulas appear as text instead of calculating on a Mac.

Fix Excel Formulas Displaying as Text on Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
The user enters a formula and wants to see its calculated result in the cell.
Observed behavior
The cell displays the formula itself rather than its result.
Before you start

Check whether the issue affects one cell or every formula in the worksheet. Select an affected cell and confirm that its entry begins with an equals sign, not an apostrophe.

Solution 1Recommended

Change the cell format and re-enter the formula

Use this fix when an individual formula cell is formatted as Text.

1
Select the affected cell

Click the cell displaying the formula, then open the Home tab.

2
Set the format to General

In the Number Format menu on the Home tab, choose General instead of Text.

3
Re-enter the formula

Double-click the cell or select it and click the formula bar, then press Enter. Changing the format alone may not convert the existing text into a formula.

Change the cell format and re-enter the formula
Check the first character: If the entry has an apostrophe before the equals sign, remove it in the formula bar and press Enter.
WPS Spreadsheet

Fix a Formula Displayed as Text in WPS Spreadsheet

Open your workbook in WPS Spreadsheet, change the affected cell to General, and re-enter the formula to calculate its result.

  1. 1. Open the workbook: Launch WPS Office, choose Open, and select your Excel workbook.
  2. 2. Select the formula cell: In WPS Spreadsheet, click the cell that displays the formula as text.
  3. 3. Choose General format: On the Home tab, open the number format menu and select General.
  4. 4. Re-enter the formula: Double-click the cell, remove any apostrophe before the equals sign, and press Enter.
Re-enter formulas after changing text-formatted cells to GeneralOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does changing the cell format to General not immediately calculate the formula?

Excel may retain the existing entry as text. After selecting General on the Home tab, double-click the cell or click the formula bar and press Enter to re-enter it.

Why are all formulas visible in my Excel worksheet?

Show Formulas may be enabled. Open the Formulas tab and click Show Formulas to turn it off.

What does an apostrophe before a formula mean?

A leading apostrophe tells Excel to treat the entry as text. Select the cell, remove the apostrophe in the formula bar, and press Enter.

Can I paste the formula into a different cell?

Yes. Set the destination cell's number format to General on the Home tab, then paste the formula into it.