Formatting Issues

Enter Long Numbers in Excel Without Losing Digits

Emma BrownEmma Brown Nov 18, 2026 869 views

Question details

The user needs to enter a 16-digit value in Excel without changing its digits.

Enter Long Numbers in Excel Without Losing 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.
Before you start

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.

Solution 1Recommended

Format Excel cells as Text before entering long numbers

Use this method when entering or pasting long identifiers into one or more cells.

1
Select the destination

In Excel, select the cell or column where you want to enter the long number.

2
Apply the Text format

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

3
Enter the original digits

Type or paste the original value, such as 7080051902836478, into the formatted cell and press Enter.

Format Excel cells as Text before entering long numbers
Text values are not numeric quantities: The digits are preserved as text, so the entry will not behave like a numeric value in calculations.
Preserve long numbers in WPS

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. 1. Open the spreadsheet: Open WPS Spreadsheets and create a workbook or open an existing Excel file.
  2. 2. Select the destination: Select the cell or column where you want to store the long identifier.
  3. 3. Choose Text format: On the Home tab, open the number format menu and choose Text.
  4. 4. Enter the original value: Type or paste the original digits into the formatted cell and press Enter.
Preserve every digit of long identifiers by storing them as textOpen and save Microsoft Excel XLSX filesUse familiar spreadsheet formatting controlsWork with spreadsheets in a free, easy-to-use office suite
microsoft office alternative - wps office

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.