Change Text to Numbers in Excel: Easy, Reliable Methods

How-to basics · Updated November 19, 2026

To change text-stored values into numbers in Excel, select the cells, click the warning icon that appears, and choose Convert to Number. If Excel does not show that option, use Data > Text to Columns > Finish for a simple column, or use a conversion formula when you need to control the result.

How to tell whether a value is stored as text

A cell can look like a number but still be text. This often happens when data comes from a website, a CSV file, another system, or a column that was formatted as Text before values were entered. Text numbers may be left-aligned by default, while ordinary numbers are usually right-aligned, but alignment is only a clue: custom formatting and alignment settings can change how either type looks.

Other signs include a small green triangle in the cell’s upper-left corner, a warning icon after you select the cell, or a formula that treats the value unexpectedly. For instance, a text value of 20 may sort before 3, and SUM may ignore text numbers in a range. To check a single cell, use =ISNUMBER(A2); with the value in A2, the result is TRUE for a number and FALSE for text. This check is useful when appearance is ambiguous.

Do not assume every digit-only value should become a number. Account codes, postal codes, product IDs, and telephone numbers are identifiers, not quantities. Converting them can remove leading zeros or change long digit strings. Keep such values as text when their digits are labels rather than amounts you intend to calculate.

Use Excel’s Convert to Number warning

For a small number of cells, Excel’s built-in correction is usually the quickest option. Select the affected cell or range, click the warning icon beside the selection, and choose Convert to Number. The warning generally appears when Excel recognizes a value that looks numeric but is stored as text. If it is not visible, click a cell with a green triangle and look for the icon beside it.

This method changes the stored value, not just its appearance. After conversion, arithmetic and numeric sorting should work normally. You can confirm by checking whether the green indicator disappears or by testing the result with ISNUMBER. If the warning menu offers several choices, read them rather than selecting one automatically; for example, ignoring the error leaves the text unchanged.

Excel’s warning system may be disabled, may not flag every cell, or may be hidden when many cells are selected. In those cases, use a method that does not depend on the warning. The conversion itself does not require changing the cell’s number format, although you may want to apply a format afterward to control decimals or separators.

Convert a whole column with Text to Columns

For a clean column of text numbers, Text to Columns is a convenient no-formula option. In Excel for Microsoft 365 on Windows, select the cells, open Data > Text to Columns, choose Delimited or leave the default selection as appropriate, and click Finish. If the column contains no delimiters that should split the values, finishing the wizard converts numeric-looking entries without dividing them.

Check the preview and destination before finishing, especially if neighboring columns contain data. Text to Columns can split values when delimiter settings are enabled, and choosing a destination can prevent the original column from being overwritten. It may also interpret dates or other patterned values; review the result rather than assuming every entry was converted as intended.

This approach is useful for a one-time cleanup, including many rows at once. It is less suitable when the source data will be refreshed repeatedly, or when values use separators that Excel interprets differently from your regional settings. On Mac, the Data tab also contains Text to Columns, though dialog layout can differ slightly by Excel release. Excel for the web has a more limited feature set; if the command is unavailable in your browser version, open the workbook in the desktop app.

Convert by multiplying with Paste Special

Multiplying numeric text by 1 can coerce it into numbers in place. Enter the number 1 in an empty cell and copy it. Select the text-number cells, then use Home > Paste > Paste Special. In the Paste Special dialog, select Multiply under Operation and confirm. Excel multiplies each selected value by one, preserving its numeric value while converting text that Excel can parse.

Use this on values intended for arithmetic, not on IDs or codes where leading zeros matter. It can also fail or produce unexpected results when cells contain letters, inconsistent separators, or other nonnumeric characters. Try it on a copy or a small sample first. On Windows, Ctrl+C copies the 1; on Mac, use Command+C. The Paste Special dialog’s labels and layout can vary slightly on Mac, but the multiply operation is available in desktop Excel.

Use a formula when you need a repeatable conversion

A formula keeps the source data intact and places converted results in another column. With a text number in A2, enter =VALUE(A2) in B2 and fill the formula down. If A2 contains the text 1250, the result in B2 is the numeric value 1250. You can then copy the results and use Home > Paste > Paste Values if you need fixed numbers rather than formulas.

VALUE uses Excel’s current regional conventions to interpret numeric text. For imported data with known separators, NUMBERVALUE lets you specify them. With the text 1,234.50 in A2, enter =NUMBERVALUE(A2,".",",") in B2; the result is 1234.5. The second argument identifies the decimal separator, and the third identifies the grouping separator. This is helpful when a file uses a convention different from the computer’s settings.

Formulas return errors if the source contains characters Excel cannot interpret as part of a number. For instance, a value with a currency symbol or hidden nonbreaking space may need cleaning first. Avoid replacing the source column until you have checked the formula results and confirmed that blanks, errors, and edge cases are handled appropriately.

Handle decimal and thousands separators

Number formats differ by region. One file may use 1,234.50, with a comma for thousands and a period for decimals; another may use 1.234,50. Excel can interpret the same text differently depending on regional settings, so a conversion that works on one computer may fail or produce a different value on another.

NUMBERVALUE is useful when you know the source convention. With text 1.234,50 in A2, use =NUMBERVALUE(A2,",",".") in B2 to specify comma decimals and period grouping; the result is 1234.5. Confirm that the separators match the actual file, not just the language you expect it to use. If a source uses spaces as grouping marks, the grouping argument can be a space, provided the text contains ordinary spaces and no other hidden characters.

Changing Windows or Excel regional settings is usually unnecessary for a one-time import and can affect other work. For recurring files, document the source format and use a formula or a repeatable import process that explicitly accounts for its separators.

Check the results and preserve important formatting

After conversion, test a few representative values, including the smallest, largest, and any entries with decimals or separators. Use ISNUMBER on the converted cells, try a simple calculation, and sort a copy of the data to see whether numeric order behaves as expected. A correct-looking display alone does not prove that the underlying value is numeric.

Keep identifiers as text when leading zeros or long digit strings must remain exact. Excel preserves only 15 significant digits for numeric values; longer numbers can lose precision when stored as numbers. This is important for tracking codes and other long identifiers. Numeric formatting can display leading zeros for some purposes, but it does not make the number an identifier or preserve digits beyond Excel’s precision limit.

Conversion and formatting are separate. A value can be numeric and still display with unwanted decimal places, or show a date because Excel interpreted it as one. Select the converted cells and use Home > Number Format to choose an appropriate display, such as Number or General. Formatting changes how a value appears; it does not convert text into a number by itself.

Use Power Query for recurring imports

If you repeatedly clean the same kind of file, Power Query can make conversion part of a refreshable process. In Excel for Microsoft 365 on Windows, select the source data and choose Data > From Table/Range. In the Power Query Editor, select the relevant column, then choose Transform > Data Type and select a suitable type, such as Whole Number or Decimal Number. Review any conversion errors, then choose Home > Close & Load.

For data whose decimal and grouping conventions differ from the computer’s locale, use the data-type conversion options that let you specify a locale, where available in the editor. This helps make an import consistent instead of relying on automatic guesses. Power Query is especially useful when a monthly report arrives in the same structure and needs the same cleanup each time. It is more setup than a one-off conversion, but refresh can apply the recorded steps to new source data.

Common problems and how to avoid them

  • Nothing changes: The cells may contain nonnumeric characters, hidden spaces, or a different decimal convention. Inspect the raw text and test a small sample with VALUE or NUMBERVALUE.
  • Leading zeros disappear: The value is likely an identifier. Keep it as text instead of converting it to a numeric value.
  • A date appears: Excel may have interpreted the text as a date. Undo if appropriate, then choose a suitable data type or import format before converting.
  • Some rows convert and others do not: The column may mix numbers with blanks, labels, currency symbols, or inconsistent separators. Filter for errors and handle each category deliberately.
  • SUM still ignores values: Check whether the conversion was applied to the actual cells and whether the formula range includes them. A number format change alone does not fix text storage.

Before applying a bulk change, save a copy or duplicate the source column. That gives you a straightforward way to compare results and recover original text if a conversion removes meaningful information.

Frequently Asked Questions

Why does Excel show numbers as text?
Values commonly arrive as text from CSV exports, web pages, or systems that preserve exact strings. A cell may also have been formatted as Text before entry, or the source may use separators that do not match Excel’s regional settings.

Can I convert text numbers without a formula?
Yes. Use the warning icon’s Convert to Number command, Text to Columns, or Paste Special with the Multiply operation. Choose based on the data: Text to Columns suits a clean column, while Paste Special is a quick bulk conversion for values you have checked.

Does changing the cell format to Number convert text?
No. Formatting controls display, not the underlying data type. Applying Number format to a text value may leave it as text; use a conversion method first, then set the display format if needed.

How do I convert text numbers with commas or periods?
Use NUMBERVALUE and specify the decimal and grouping separators used in the source. Check a known example after conversion, because the same punctuation can mean different things in different regional conventions.

Should I convert a ZIP code or product number to a number?
Usually not. These are identifiers, and converting them can remove leading zeros or reduce precision for long strings. Keep them as text unless you specifically need to perform numeric calculations on their values.

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.