Fix an Excel 2016 for Mac Array Formula Displaying as Text
Question details
The user needs an array formula to calculate instead of displaying as text in Excel 2016 for Mac.

- Product
- Microsoft Excel 2016 for Mac
- Device & OS
- Mac
- Scenario
- Entering an array formula with Command+Shift+Enter.
- Observed behavior
- The cell displays the formula as text instead of its calculated result.
Select the affected cell and check whether the formula begins with an equals sign or an apostrophe. If the formula returns multiple results, identify the full output range before editing it.
Change the cell format and re-enter the array formula
Use this when the cell is formatted as Text or the formula was entered as text.
Select the affected cell, then go to Home and choose General from the Number Format menu.
Click the formula bar and confirm that the formula starts with =. Remove any leading apostrophe before the equals sign.
With the formula active in the formula bar, press Command+Shift+Enter. For a multi-cell array formula, select the intended output range before entering it.

Turn off Show Formulas and check the formula syntax
Use this if formulas are still visible or the array formula does not calculate as expected.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet for a straightforward transition, while checking formulas for compatibility.

Frequently Asked Questions
Why does my array formula show as text after I change the cell to General?
Changing the format does not automatically re-enter existing text. Select the cell, click the formula bar, remove any leading apostrophe, and confirm the formula again with Command+Shift+Enter.
How do I stop Excel from showing all formulas instead of results?
Go to the Formulas tab and turn off Show Formulas. This setting affects the display of formulas across the worksheet.
How do I enter an array formula in Excel 2016 for Mac?
Enter the formula beginning with = and press Command+Shift+Enter. If it returns multiple values, select the intended output range before entering the formula.
Will every Excel array formula work in WPS Spreadsheet?
Not necessarily. WPS Spreadsheet can open Excel files, but formula and feature support can differ. Check the formula and its results after opening the workbook.




