Fix Excel Formulas Displaying as Text on Mac
Question details
Excel formulas appear as text instead of calculating on a 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.
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.
Change the cell format and re-enter the formula
Use this fix when an individual formula cell is formatted as Text.
Click the cell displaying the formula, then open the Home tab.
In the Number Format menu on the Home tab, choose General instead of Text.
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.

Turn off Show Formulas in Excel
Use this fix when formulas are visible throughout the worksheet.
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. Open the workbook: Launch WPS Office, choose Open, and select your Excel workbook.
- 2. Select the formula cell: In WPS Spreadsheet, click the cell that displays the formula as text.
- 3. Choose General format: On the Home tab, open the number format menu and select General.
- 4. Re-enter the formula: Double-click the cell, remove any apostrophe before the equals sign, and press Enter.

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.




