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

> How to convert text to numbers in Excel on Mac: use the error indicator, Paste Special, or VALUE. Steps for Microsoft 365, plus fixes when it fails.

URL: https://www.lazur.app/how-to/convert-text-to-numbers-in-excel
Updated: 2026-11-09

To convert text to numbers in Excel on Mac, select the flagged cells, click the error indicator at their top-left corner, and choose Convert to Number. If no indicator appears, turn on background error checking in Excel > Preferences > Error Checking, or use a VALUE formula and Paste Values instead.

## Quick answer

- Select the flagged cells, click the error indicator, and choose Convert to Number.
- If no indicator appears, go to Excel > Preferences > Error Checking and turn on background error checking.
- Changing the number format does not convert values that are already text.
- When the flag is missing, put =VALUE() in a helper column, then Paste Values over the original cells.
- Excel stores 15 digits of number precision, so keep long IDs as text.

Applies to: Excel for Microsoft 365, Excel 2024 and Excel 2021 on Mac. Time: 6 min. Difficulty: Easy.

## What you need

- Excel for Mac: Microsoft 365, Excel 2024, or Excel 2021, the versions Microsoft's guide lists
- The sheet open, with the cells you want to fix visible
- An untouched copy of the sheet for testing
- Background error checking turned on, if you expect the error indicator

## How to Convert text-stored numbers to real numbers in Excel on Mac in Excel on a Mac

1. **Select the flagged cells.** Click the first cell that holds a text number, then drag down to the last one in the column. Include only the cells that need converting. Leave headers and totals out of the selection. Look for a small green triangle in each cell's corner.
2. **Click the error indicator.** (Error indicator) Hover over the selection. An error indicator appears at the top-left corner of the selected cells. Click it to open the menu. Microsoft's guide uses this name, and Mac builds may draw the icon differently. Tip: If nothing appears, check the background error checking setting in the section above.
3. **Choose Convert to Number.** (Error indicator > Convert to Number) In the menu, click Convert to Number. Excel changes the selected values into numbers. The green triangles disappear from those cells.
4. **Check the result.** Type =SUM( in an empty cell, drag across the column, close the parenthesis, and press Return. A total that matches what you expect means the cells now hold numbers.
5. **Turn on background error checking if no flag appears.** (Excel > Preferences > Error Checking) Open Excel > Preferences > Error Checking. Select Enable background error checking. Some builds label it Turn on background error checking. Close the dialog, then select the cells again. Tip: This setting only changes how Excel flags cells. It does not convert anything by itself.
6. **Add a helper column with VALUE.** Insert a blank column next to the text values. In its first cell, type =VALUE( and click the first text cell. Close the parenthesis and press Return. Fill the formula down to the last row.
7. **Copy the helper results.** Shortcut: ⌘C. Select the helper cells and press ⌘C. Then click the first original text cell so the paste lands in the right place.
8. **Paste Values over the originals.** (Home > Paste > Paste Special) Shortcut: ⌘⌃V. With the original cells selected, choose Home > Paste > Paste Special. Choose Values, then click OK. Check the totals, then delete the helper column. Tip: Exceljet lists ⌘⌃V for Paste Special on Mac. Check it on your build.

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.

![Person at a desk converting text to numbers in Excel on a Mac laptop](https://images.lazur.app/content-images/howto/convert-text-to-numbers-in-excel/how-to-convert-text-to-numbers-in-1-d1c425.jpg)

## 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 | Best when | Watch for |
| --- | --- | --- |
| Error indicator | The flag appears on the cells you need | Some Mac builds may draw the indicator differently |
| VALUE and Paste Values | No flag, or you want to check results first | Pasting before you check errors copies them into the originals |
| Multiply by 1 with Paste Special | The other methods fail on a copy of the sheet | A 2023 Q&A original poster said it changed cell formatting |

_Three ways to convert text numbers in Excel on Mac_

## 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.

- **15** Digits of number precision Microsoft lists as an Excel limit, so long IDs belong in text ([source](https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3))
- **94%** Of business spreadsheets reported to contain errors in a 2024 literature review, not a user survey ([source](https://phys.org/news/2024-08-business-spreadsheets-critical-errors.html))

## 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.

![Accountant reviewing spreadsheet columns before converting text numbers in Excel on Mac](https://images.lazur.app/content-images/howto/convert-text-to-numbers-in-excel/how-to-convert-text-to-numbers-in-2-56c91c.jpg)

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.

> **Test on a copy:** In the one reported case, Multiply by 1 changed the cell formatting. Keep an untouched copy of the sheet before you run it on real data, and delete the 1 cell when you finish.

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.

![Man checking a spreadsheet on a laptop after fixing numbers stored as text in Excel on Mac](https://images.lazur.app/content-images/howto/convert-text-to-numbers-in-excel/how-to-convert-text-to-numbers-in-3-3e9874.jpg)

## 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](https://www.lazur.app/how-to/make-a-pivot-table-in-excel). For matching values across sheets, read [How to use XLOOKUP in Excel on Mac](https://www.lazur.app/how-to/use-xlookup-in-excel).

## Shortcuts

- Paste Special: ⌘⌃V
- Copy selected cells: ⌘C

## If it does not work

- **The Convert to Number option doesn't appear** Select the flagged cells again. Check Excel > Preferences > Error Checking and turn on background error checking. If the option still doesn't appear, use the VALUE method instead.
- **Changing the number format left the numbers as text** Changing the format does not convert values already in the cells. Use the error indicator, VALUE with Paste Values, or the Multiply by 1 method.
- **Cells still act like text after conversion** Look for hidden spaces. A 2018 Microsoft Q&A reply for Excel 2016 for Mac suggested =--TRIM(SUBSTITUTE(C1,CHAR(160),"")) to strip a non-breaking space. Test it on a copy first, because the thread did not confirm it on current builds.
- **Multiply by 1 changed my cell formatting** A 2023 Q&A original poster reported the same change. Reapply the number format you want from Home > Number group > Dialog Box Launcher, and keep an untouched copy of the sheet next time.
- **Long account or card numbers changed** Excel's number precision limit is 15 digits. Restore the column from your untouched copy, keep ID columns as text, and convert only the amount columns.
- **The Paste Special shortcut does nothing** Use the menu instead. Choose Home > Paste > Paste Special, or Edit > Paste Special, and pick Values or Multiply from there.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where's the Convert to Number option?”: Lazur circles Convert to Number and labels it on your screen. It explains what the change does to the selected cells, out loud. You click it yourself. (Points at it)

## FAQ

### Why does Excel show numbers as text on Mac?

Excel stores a value as text when it arrives that way. Common sources are web pages, exports, CSV imports, and values typed after an apostrophe. Excel flags those cells so you can convert them.

### Does the error indicator work in Excel for Mac?

Microsoft's guide lists Excel for Microsoft 365 for Mac, Excel 2024 for Mac, and Excel 2021 for Mac as applicable. A 2023 Q&A thread says the smart tag may be missing on some builds, so use VALUE if you don't see it.

### Can I convert a whole column at once?

Yes, select the cells you want to fix, then use the error indicator on that selection. If the column also holds IDs or notes, select only the rows that hold amounts.

### Should I convert every column in the sheet?

No. Convert the columns you add or average. Keep IDs, codes, and labels as text, because Excel stores only 15 digits of number precision.

### What is the Mac shortcut for the error indicator?

No official Mac shortcut turned up for the error indicator. Microsoft lists Alt+Shift+F10, which is a Windows shortcut. For Paste Special on Mac, Exceljet lists ⌘⌃V.

### Why didn't changing the number format fix my numbers?

Changing the format does not change the values already in the cells. Use the error indicator, VALUE with Paste Values, or the Multiply by 1 method instead.

### Will the Multiply by 1 method change my formatting?

It might. The original poster in a 2023 Microsoft Q&A said it worked but changed their cell formatting. Test on a copy of the sheet first.

### Why do my long account numbers change after conversion?

Microsoft lists a 15-digit number precision limit for Excel. Keep long IDs as text, and convert only the columns that hold amounts.

## Sources

1. [Convert numbers stored as text to numbers in Excel](https://support.microsoft.com/en-us/excel/convert-numbers-stored-as-text-to-numbers-in-excel), Microsoft Support, checked 2026-11-09
2. [Fix text-formatted numbers by applying a number format](https://support.microsoft.com/en-us/excel/fix-text-formatted-numbers-by-applying-a-number-format), Microsoft Support, checked 2026-11-09
3. [Detect formula errors in Excel](https://support.microsoft.com/en-us/excel/detect-formula-errors-in-excel), Microsoft Support, checked 2026-11-09
4. [Excel on MacOS not changing cell data type, Microsoft Q&A](https://learn.microsoft.com/en-us/answers/questions/5261401/excel-on-macos-not-changing-cell-data-type), Microsoft Learn Q&A, checked 2026-11-09
5. [Convert number stored as text to number: Excel 2016 for Mac High Sierra, Microsoft Q&A](https://learn.microsoft.com/en-us/answers/questions/4977181/convert-number-stored-as-text-to-number-excel-2016), Microsoft Learn Q&A, checked 2026-11-09
6. [Release notes for Office for Mac](https://learn.microsoft.com/en-us/officeupdates/release-notes-office-for-mac), Microsoft Learn, checked 2026-11-09
7. [Excel specifications and limits](https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3), Microsoft Support, checked 2026-11-09
8. [Excel shortcuts on the Mac](https://exceljet.net/articles/excel-shortcuts-on-the-mac), Exceljet, checked 2026-11-09
9. [Excel Options and Settings (Windows and Mac)](https://exceljet.net/options), Exceljet, checked 2026-11-09
10. [Study finds 94% of business spreadsheets have critical errors](https://phys.org/news/2024-08-business-spreadsheets-critical-errors.html), Phys.org, checked 2026-11-09