How to convert text to numbers in Excel on Mac: fixes for Microsoft 365

Excel treats a value as text when it arrives that way. A number pasted from a web page, imported from a file, or typed after an apostrophe can land as text. The cell looks like a number. Excel still treats it as text, so formulas may skip it.

Why Excel keeps numbers as text on Mac

Numbers stored as text usually come from outside Excel. You might copy a column from a website, open an export from another system, or import a CSV file. Each route can carry values in text form. Excel then marks those cells so you can spot them and convert them.

Microsoft's support guide on this problem covers Excel for Microsoft 365 for Mac, Excel 2024 and Excel 2021 for Mac, and the web app. It gives no Mac-specific menu paths or shortcuts. So this page labels every Mac-specific step. Some come from Microsoft's Mac pages, and some come from community threads.

Which method should you pick

Start with the error indicator if it shows up. If it doesn't, use VALUE with Paste Values. The Multiply by 1 method is the last resort, because one reported case changed the cell formatting.

Method 1: Convert with the error indicator

This route is the fastest, and it is the one Microsoft describes first. You select the flagged cells, click the error indicator in the top-left corner of the selection, and choose Convert to Number. Excel converts the values in place. The green triangles disappear.

Read the first three steps before you click anything. Select only the columns you want to fix. Leave headers and notes out of the selection, because they are not numbers. If you can't find the indicator, the next section explains the setting it depends on.

Turn on background error checking

The indicator depends on a setting. Microsoft's Detect formula errors page says to open the Excel menu, choose Preferences, then Error Checking, and select Enable background error checking. Exceljet lists the same option as Turn on background error checking. Match the label to what your Excel shows.

Changing this setting doesn't convert anything. It only tells Excel to flag cells in the background. Select the cells again after you change it, so the flag has a chance to appear on them.

Method 2: Use VALUE and Paste Values

The VALUE function reads text and returns a number. You place it in a helper column, copy the results, and paste them as values over the original cells. Microsoft describes this method for Windows and the web, and says the web steps are the same. On a Mac, Command replaces Ctrl.

Take a simple case. Your amounts sit in column A, starting at row 2, and they look like numbers but act like text. Insert a blank column to the right. In the first helper cell, type =VALUE(A2), press Return, and fill the formula down to the last row of the list.

When the helper column shows numbers, copy it with ⌘C. Click the first original cell and paste with Paste Special set to Values. The original column now holds real numbers. Delete the helper column last, after you check that the totals match what you expect.

Watch for errors in the helper column. If VALUE returns an error for a row, that cell holds text that is not a plain number, such as a note or a word. Fix or clear that cell before you paste. Otherwise the error lands in the original column.

Method 3: Multiply by 1 with Paste Special

This fallback comes from a 2023 Microsoft Q&A thread. An MVP named Bob Jones suggested it for Excel on Mac. Type 1 in an empty cell and copy it. Select the text cells, then choose Edit > Paste Special. Under Operation, pick Multiply, and click OK. Excel does the arithmetic on each value, so the results come out as numbers.

The original poster said the method worked. The thread also says the smart tag may no longer appear on their build. That matches what you may see on your Mac, so treat this method as a fallback, not a first choice.

Why changing the number format doesn't work

Many people open Home > Number group > Dialog Box Launcher and choose Number. In a 2023 Microsoft Q&A, a user on Excel 16.78.3 with macOS 12.7 found the values stayed as text. A volunteer moderator said changing the format does not change the values. The fix is the Convert to number option on the flagged cells.

Microsoft's page on applying a number format describes this approach. That page lists only Windows shortcuts and names Excel 2013 as the applicable version. Use it as background. It is not the fix for current Mac builds.

Check the converted column before you trust it

Converting is only half the job. Type =SUM( in an empty cell below the column, drag across the converted cells, close the parenthesis, and press Return. Then compare the total with a figure you already know, such as a subtotal from the source system.

If the total comes back as zero, the cells are still text. If it is short by a few rows, look for cells that hold a space or a note. Sorting the column once also helps. Converted numbers sort by size, and any text left behind sorts to the bottom.

Amounts versus long IDs: what to convert

Not every text number should become a number. Amounts, quantities, and dates are safe to convert, because you will add or average them. Long identifiers such as account numbers, tracking codes, and card numbers need a different rule. Keep them as text.

Microsoft lists 15 digits as the number precision limit for Excel. The page doesn't say whether the limit applies to storage or display. Either way, a long ID is a poor fit for a number cell. That is the reason to keep IDs as text from the start.

A simple rule works on most sheets. Convert the columns you calculate with. Leave columns you only look up or sort by as text. If one column mixes both, select only the rows that hold amounts, not the whole column.

Mistakes people make with text numbers

• Converting ID columns. Long IDs can lose precision once they become numbers, so keep them as text.
• Changing the number format and expecting old values to update. They won't.
• Deleting the helper column before pasting. You need it as the source for the values.
• Using a plain Paste instead of Paste Special. A plain paste copies formulas, so the original column can keep running VALUE.
• Skipping the backup. Multiply by 1 changed formatting in the one reported case.
• Searching for a Mac shortcut for the error indicator. Microsoft lists Alt+Shift+F10, which is a Windows shortcut. No official Mac equivalent turned up in research.

Check your Excel build before you troubleshoot

The latest Mac build in Microsoft's release notes is Excel 16.114.3 (Build 26102720), released October 27, 2026. The notes describe quality and performance improvements. They do not describe changes to this feature. If your screen differs from this guide, check your build first.

Open Excel > About Excel to see yours. The previous builds were 16.114.2 (Build 26102345) on October 26, 2026, and 16.114.1 (Build 26102031) on October 22, 2026. Newer builds may move menu items, so compare names, not positions.

How common is this problem?

No survey of how often people hit this specific error turned up in research. The closest number comes from a 2024 literature review led by Pak-Lok Poon. It reported that 94% of spreadsheets used in business decision-making contain errors.

That review covers spreadsheet errors in general. It does not measure text-stored numbers, and the source gives no sample size. Use it as context for why checking your numbers matters, not as proof of how often this bug appears.

Where to go next

Once the numbers work, the usual next step is a total, a summary, or a lookup. A pivot table groups the cleaned amounts well. The pivot guide is at How to make a pivot table in Excel on Mac. For matching values across sheets, read How to use XLOOKUP in Excel on Mac.