Enter Long Numbers in Excel Without Losing Digits
Question details
The user needs to enter a 16-digit value in Excel without changing its digits.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering a long identifier or other value that must retain every digit.
- Observed behavior
- Excel changes 7080051902836478 to 7080051902836470 because numeric values are limited to 15 significant digits.
Have the original digits available before changing the cell format. If Excel has already changed the value, formatting the cell as Text will not restore the lost digits; you must enter them again.
Format Excel cells as Text before entering long numbers
Use this method when entering or pasting long identifiers into one or more cells.
In Excel, select the cell or column where you want to enter the long number.
On the Home tab, open the Number Format drop-down and select Text.
Type or paste the original value, such as 7080051902836478, into the formatted cell and press Enter.

Use an apostrophe before a long Excel entry
Use this shortcut to preserve the digits in an individual cell without changing its format first.
Keep Long Identifiers Intact in WPS Spreadsheets
In WPS Spreadsheets, format the destination as Text before entering a long identifier so its digits are stored as text.
- 1. Open the spreadsheet: Open WPS Spreadsheets and create a workbook or open an existing Excel file.
- 2. Select the destination: Select the cell or column where you want to store the long identifier.
- 3. Choose Text format: On the Home tab, open the number format menu and choose Text.
- 4. Enter the original value: Type or paste the original digits into the formatted cell and press Enter.

Frequently Asked Questions
Why does Excel change the last digit of my 16-digit number?
Excel supports only 15 significant digits for numeric values. Store long identifiers as text before entering them to preserve every digit.
Can I recover digits by changing an existing cell to Text?
No. Select Text from Home > Number Format, then re-enter the original digits from your source.
Will the apostrophe appear in the cell?
No. When you type an apostrophe before the digits, Excel stores the entry as text but does not display the leading apostrophe in the cell.
Can I use a long number stored as text in calculations?
A text entry is not a numeric quantity. Converting it to an Excel number for calculation can again lose digits beyond the 15-digit precision limit.




