Data Import & Export

Convert Numbers Stored as Text in Excel

Chanuka GeekiyanageChanuka Geekiyanage Nov 22, 2026 868 views

Question details

The user needs to convert numbers stored as text into numeric values while avoiding unwanted rounding of long identifiers.

How to Convert Numbers Stored as Text in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Values in an Excel column appear to be numbers but do not respond as expected to number formatting. Some values contain more than 15 digits.
Observed behavior
Changing the number format alone does not convert text to numbers, and a 16-digit value can be rounded when stored as a numeric value.
Before you start

Check whether the affected values are quantities used in calculations or identifiers that must retain every digit. For values longer than 15 digits, locate the original text or source data before converting or reimporting them.

Solution 1Recommended

Convert text values to numbers with Text to Columns

Use this method for values that need to be calculated and have no more than 15 significant digits.

Changing a cell's number format does not convert existing text into a numeric value. Text to Columns can perform that conversion.

1
Select the affected values

Select the cells in the affected column. On the Home tab, choose Number from the Number Format menu if you want the converted values displayed as numbers.

2
Open Text to Columns

Go to Data > Text to Columns. Choose Delimited and click Next.

3
Complete the conversion

Clear the delimiter checkboxes if each cell contains one value, click Next, select General as the column data format, and click Finish.

4
Check the results

Select a converted cell and inspect its value in the formula bar. Apply the desired format from Home > Number Format.

Excel's precision limit: Excel stores only 15 significant digits in numeric values. Converting a longer value to a number can change its trailing digits.
Work with spreadsheet values

Convert text-formatted numbers in WPS Spreadsheets

Use Text to Columns in WPS Spreadsheets to convert suitable text values into numbers, or format long identifiers as text before entering them.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Select the values: Select the cells in the column containing numbers stored as text.
  3. 3. Convert the values: Choose Data > Text to Columns, follow the wizard, select General as the column format, and click Finish.
  4. 4. Preserve long identifiers: For identifiers longer than 15 digits, select the destination cells, choose Text from the Home tab's number format menu, and enter or paste the original digits.
Convert text-formatted values for calculationsPreserve long identifiers by entering them as textOpen and edit Microsoft Excel XLS and XLSX filesWork with a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't changing the number format convert my text values?

The number format controls how numeric values are displayed; it does not change text into numbers. Select the affected cells and use Data > Text to Columns with the General column format to convert them.

Why did Excel change the last digit of my 16-digit number?

Excel stores numeric values with a maximum of 15 significant digits, so additional digits can be rounded. Store long identifiers as text and reenter them from the original source if they were already changed.

Does left alignment always mean a number is stored as text?

No. Text is often left-aligned by default, but alignment can be changed manually. Check whether the value converts through Data > Text to Columns or use a formula such as =ISTEXT(A1) to test it.

Can I recover digits after Excel has rounded a number?

Not by changing the cell format. Retrieve the original digits from the source, format the destination cells as Text under Home > Number Format, and reenter or reimport the values.