Why Excel Changes 16-Digit Numbers and How to Preserve Them
Question details
The user wants to preserve every digit in a number longer than 15 digits in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering or importing long identification numbers into a spreadsheet.
- Observed behavior
- Excel stores only 15 significant digits in numeric values, so later digits may be replaced with zeros.
Find the original number in its source, because formatting a value after Excel has changed its digits will not restore them. Identify the cells or column that should store the numbers as text.
Format cells as Text before entering long numbers
Use this method for identification numbers that must retain every digit exactly.
In Excel, select the cells or column where you want to enter the long numbers.
On the Home tab, open the Number Format drop-down and select Text.
Type or paste the original numbers into the formatted cells, then check that every digit is present.

Prefix an individual number with an apostrophe
Use an apostrophe to store a single long identification number as text while entering it.
Keep long identification numbers as text in WPS Spreadsheet
Format cells as Text in WPS Spreadsheet before entering or pasting long identification numbers to preserve their digits.
- 1. Open your spreadsheet: Open WPS Spreadsheet and create a workbook or open an Excel file.
- 2. Select the target cells: Select the cells or column where you will enter the identification numbers.
- 3. Set the format to Text: Open Format Cells, choose Text under the Number category, and confirm.
- 4. Enter the original numbers: Type or paste the original values into the formatted cells and check that all digits appear.

Frequently Asked Questions
Why does Excel change the last digit of a 16-digit number?
Excel stores numeric values with up to 15 significant digits. Digits beyond that limit may be replaced with zeros, so long identifiers should be entered as text.
Can I recover digits that Excel has already changed?
Changing the cell format cannot restore lost digits. Retrieve the original number from its source, format the cell as Text using Home > Number Format, and re-enter it.
Will an apostrophe appear in the cell?
When you type an apostrophe before a number in a cell, Excel normally displays the number without the apostrophe and stores the value as text.
How can I preserve long numbers when importing a CSV file?
Use Data > From Text/CSV rather than opening the file directly. If available, turn off automatic data type detection, select Transform Data, and set the identifier column to Text before loading it.




