Convert Text to Number in Excel Quickly

How-to basics · Updated November 20, 2026

To quickly convert text to numbers in Excel, select the affected cells and choose Convert to Number from the warning icon, if it appears. If there is no warning icon, select the column and use Data > Text to Columns > Finish; for a formula-based conversion, use =VALUE(A2) in a helper column.

Start with the fastest method

Excel often marks numbers stored as text with a small green triangle in the cell’s upper-left corner. This commonly happens after importing a CSV, copying data from a website, or receiving a report produced by another system. The value can look like a number and sit beside other numbers, yet Excel may treat it as text, so calculations and numeric sorting do not behave as expected.

  1. Select one affected cell, or select the entire range containing the text numbers.
  2. Click the warning icon that appears beside the selection.
  3. Choose Convert to Number.

For a single cell, the warning icon may appear next to that cell. When a range is selected, Excel may offer the command for the selected cells. The icon is not guaranteed to appear: its visibility depends on Excel’s error-checking settings and whether Excel recognizes the values as numbers stored as text. If you do not see it, use Text to Columns or a formula instead.

Convert a whole column with Text to Columns

Text to Columns is a practical choice when many cells need conversion and the range contains ordinary numeric text. It can convert the selected values in place, so you do not need to build a formula column and copy results back. In Excel for Microsoft 365 on Windows:

  1. Select the cells or the single column to convert. Avoid selecting neighboring columns that contain unrelated data.
  2. Choose Data > Text to Columns.
  3. In the wizard, choose Delimited and select Next.
  4. Leave the delimiter boxes clear if the selected cells are whole values, then select Next.
  5. Choose General for numeric values and select Finish.

Although the command is designed to split text into columns, it can also make Excel reinterpret values in a selected column. Check the result afterward, especially if the cells include dates, decimal separators, or identifiers. In Excel for Mac, use the Data tab and Text to Columns command if available in your version; wizard layout can differ. Excel for the web has a more limited feature set, so a formula or opening the workbook in the desktop app may be more convenient.

Use VALUE when you want a formula

A formula is useful when you want to preserve the original imported data, document the conversion, or convert only selected rows. With the text value in A2, enter =VALUE(A2) in B2. If A2 contains the text 1250.5 and Excel’s regional settings recognize a period as the decimal separator, B2 returns the numeric value 1250.5.

Fill the formula down to the other rows using the fill handle, then inspect the results. If you need the converted values to replace the source, copy the formula results and use Home > Paste > Paste Values over the original range. Keep a copy of the source data until you have verified the converted column. VALUE returns an error if the text cannot be interpreted as a number under the workbook’s locale and formatting conventions.

Changing a cell’s number format to Number is not the same as converting text to a number. Formatting controls how a value is displayed; it does not necessarily change the underlying text into a numeric value. If a cell still fails a calculation after you apply Number format, use one of the conversion methods above.

Choose a method that fits the data

The best method depends on the size of the range and what the values represent. For a small set of ordinary numbers, the warning icon is usually quickest. For a clean column of imported values, Text to Columns avoids adding a helper column. A formula is more transparent and easier to check when the source must remain intact or only some rows need conversion.

  • Warning icon: Fast for a few cells or a range Excel has flagged. It requires no extra column, but may not be available.
  • Text to Columns: Convenient for a whole column of consistent data. It changes the selected cells, so save or preserve the original if the data is important.
  • VALUE formula: Good for repeatable or auditable work. It leaves the source unchanged until you choose to replace it with values.
  • Paste Special with Multiply: A quick bulk workaround for ordinary numeric text. Enter 1 in a blank cell, copy it, select the target cells, then choose Home > Paste > Paste Special and select Multiply. Check the results; this operation changes the selected cells directly.

Do not use bulk conversion on a mixed column without checking what each entry means. A column may contain amounts, labels, dates, and codes together even if many of the cells look numeric.

Check decimal separators and imported formats

Excel interprets text according to regional settings and the characters used in the source. For example, 1,234.56 and 1.234,56 represent the same amount in different number conventions. If the workbook’s settings do not match the source, conversion may fail or may interpret a separator differently than intended. Do not assume a value converted correctly just because it no longer has a green triangle.

Before converting a large import, inspect several representative cells: one with a decimal part, one with a thousands separator, and one with a minus sign if present. For CSV files, the import process may provide options for choosing the file origin, delimiter, and data types; choosing suitable import settings can prevent text-number problems in the first place. If a value includes currency symbols, spaces, or other characters, it may need cleaning before VALUE can interpret it. Remove only characters you know are not part of the actual value.

After conversion, test the column with a simple calculation or sort it numerically. For example, numeric sorting should place 2 before 10, while a text sort may place 10 before 2. A total can also help identify values that remain text, though a total alone is not proof that every row is correct.

Protect dates, codes, and leading zeros

Not every string of digits should become a number. Product codes, postal codes, account references, and other identifiers are labels, not quantities. A code such as 00127 loses its leading zeros if converted to the number 127. If those zeros are meaningful, keep the value as text or apply a deliberate display format designed for the code. Do not convert identifiers merely to make them align with a numeric column.

Dates need similar care. Excel stores recognized dates as serial numbers and displays them using a date format. Text to Columns can reinterpret date-like text, but a day-month order such as 04/05/2025 can mean different dates in different regions. If the date order matters, specify the correct date format in the Text to Columns wizard or use an import process that identifies the source format. Review the displayed dates after conversion, not just the underlying values.

Large integers also deserve attention. Excel provides about 15 significant digits of numeric precision; longer numeric identifiers can lose precision when treated as numbers. Keep such values as text if every digit must remain exact. This is another reason that “make all digits numeric” is not a safe rule for every spreadsheet column.

Troubleshoot values that will not convert

If a conversion produces an error or leaves a cell behaving like text, look for invisible or unexpected characters. Data copied from web pages can contain nonbreaking spaces, and imported values may have leading or trailing spaces, apostrophes, or currency symbols. A cell can appear to contain only digits while still including a character Excel does not recognize as part of a number.

  • Click the cell and inspect the formula bar for a leading apostrophe or extra characters.
  • Compare a failing value with a value that converted successfully, including the decimal and thousands separators.
  • Check whether the column mixes numbers with words, units, blank-looking strings, or error values.
  • Clean only confirmed unwanted characters, then retry conversion on a small sample before applying it to the full range.

A further common issue is that a formula returns text even though its result looks numeric. If the source formula uses text-building functions or places a number inside text, the displayed digits may not be a numeric result. VALUE can convert a recognizable numeric string, but it cannot repair every inconsistent or malformed value automatically. Fixing the source formula or import settings is often more reliable than repeatedly applying conversion commands.

Verify the result before using it

After conversion, test more than the appearance of the cells. Try a numeric sort, use the values in an appropriate calculation, and check a few cells individually. You can also change the number format temporarily to see whether the value responds as expected, but remember that formatting alone is not conclusive evidence that text was converted.

For an important workbook, compare the row count and a few known values with the original source. Watch for unintended changes to dates, leading zeros, long codes, and values with decimal separators. If the conversion was made in place, keeping an untouched source sheet or backup makes it easier to recover from an incorrect interpretation.

Frequently Asked Questions

Why does Excel show a number as text?
It may have been imported or pasted as text, include an apostrophe or extra space, or use separators Excel does not recognize under the current regional settings. The cell can look numeric while Excel treats it as text.

What is the quickest way to convert text to numbers in Excel?
If the warning icon appears, select the cells and choose Convert to Number. For a column without that option, Data > Text to Columns > Finish is a quick alternative for consistent numeric text.

Does changing the cell format to Number convert text?
No. Number format changes how Excel displays a value; it does not reliably turn a text string into a numeric value. Use a conversion command or a formula such as =VALUE(A2).

How can I convert text to numbers without losing leading zeros?
Keep codes that require leading zeros as text. Converting 00127 to a number produces 127, so numeric conversion is unsuitable when the zeros are part of the identifier.

Why does VALUE return an error?
The text may include spaces, symbols, or separators that Excel does not recognize, or it may not represent a valid number. Check the source format and regional settings, then clean confirmed extraneous characters or correct the import.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.