Convert Numbers Stored as Text in Excel
Question details
The user needs to convert numbers stored as text into numeric values while avoiding unwanted rounding of long identifiers.

- 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.
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.
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.
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.
Go to Data > Text to Columns. Choose Delimited and click Next.
Clear the delimiter checkboxes if each cell contains one value, click Next, select General as the column data format, and click Finish.
Select a converted cell and inspect its value in the formula bar. Apply the desired format from Home > Number Format.
Keep long numbers as text to preserve every digit
Use text for account numbers, IDs, and other values longer than 15 digits that do not require arithmetic.
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. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Select the values: Select the cells in the column containing numbers stored as text.
- 3. Convert the values: Choose Data > Text to Columns, follow the wizard, select General as the column format, and click Finish.
- 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.

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.




