Formula Errors

Fix an Excel 2016 for Mac Array Formula Displaying as Text

Tauseeq MagsiTauseeq Magsi Nov 22, 2026 868 views

Question details

The user needs an array formula to calculate instead of displaying as text in Excel 2016 for Mac.

Fix an Array Formula 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.
Before you start

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.

Solution 1Recommended

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.

1
Set the cell to General

Select the affected cell, then go to Home and choose General from the Number Format menu.

2
Edit the formula

Click the formula bar and confirm that the formula starts with =. Remove any leading apostrophe before the equals sign.

3
Confirm the array formula

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.

Change the cell format and re-enter the array formula
Re-entry is necessary: Changing the format to General does not automatically convert an existing text entry into a formula; edit and confirm it again.
Free Microsoft Office alternative

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.

Review and edit spreadsheet formulas in WPS SpreadsheetOpen and save Microsoft Excel formats such as XLSX and XLSNavigate a familiar, easy-to-use interfaceUse a free, lightweight office suite
QA img-9

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.