Calculation Issues

Why Excel Changes 16-Digit Numbers and How to Preserve Them

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 870 views

Question details

The user wants to preserve every digit in a number longer than 15 digits in Excel.

Why Excel Changes 16-Digit Numbers and How to Preserve Them
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.
Before you start

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.

Solution 1Recommended

Format cells as Text before entering long numbers

Use this method for identification numbers that must retain every digit exactly.

1
Select the cells

In Excel, select the cells or column where you want to enter the long numbers.

2
Apply Text format

On the Home tab, open the Number Format drop-down and select Text.

3
Enter the original values

Type or paste the original numbers into the formatted cells, then check that every digit is present.

Format cells as Text before entering long numbers
Existing values must be re-entered: Changing a cell to Text after Excel has already replaced digits with zeros does not recover the original digits. Re-enter the value from its source.
Preserve long numbers

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. 1. Open your spreadsheet: Open WPS Spreadsheet and create a workbook or open an Excel file.
  2. 2. Select the target cells: Select the cells or column where you will enter the identification numbers.
  3. 3. Set the format to Text: Open Format Cells, choose Text under the Number category, and confirm.
  4. 4. Enter the original numbers: Type or paste the original values into the formatted cells and check that all digits appear.
Preserve long identification numbers and leading zeros as textOpen and save Microsoft Excel XLSX filesUse familiar spreadsheet formatting controls
microsoft office alternative - wps office

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.