How to Store and Calculate 16-Digit Numbers in Excel
Question details
The user needs to store or calculate numbers with 16 or more digits in Excel without the application automatically converting the final digits to zeros.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Entering long numeric identifiers, such as credit card numbers or very large integers, into spreadsheet cells for tracking or mathematical calculation.
- Observed behavior
- Excel preserves only up to 15 significant digits for ordinary numeric values, permanently altering 16-digit identifiers by changing the 16th digit to a zero.
Determine whether your 16-digit numbers are merely for identification (like a credit card or ID number) or if they require actual mathematical calculations, as this dictates the solution you must use.
Format Cells as Text to Safely Store Identifiers
The standard and most reliable way to prevent Excel from altering 16-digit numbers is to format the target cells as Text before entering any data.
Excel uses the IEEE 754 standard for floating-point calculations, which inherently limits precision to 15 significant digits. By converting cells to Text format, you instruct Excel to treat the entry as a string of characters rather than a mathematical value, bypassing the 15-digit limitation.
Highlight the empty cells or entire columns where you plan to input your 16-digit numbers.
Right-click the selected area and choose 'Format Cells' from the context menu to open the formatting dialog.
Navigate to the 'Number' tab, select 'Text' from the Category list on the left, and click 'OK'.
Type your 16-digit numbers into the newly formatted cells. Excel will now preserve every digit exactly as you typed it.

Use Specialized Add-ins for Large Integer Calculations
If you must perform exact arithmetic operations on numbers exceeding 15 digits, standard Excel functions will not work and external tools are required.
Store 16-Digit Numbers as Text in WPS Spreadsheet
WPS Spreadsheet offers a highly intuitive interface to quickly format cells as text, allowing you to safely store credit card numbers and long identifiers without losing any digits.
- 1. Open your workbook: Launch WPS Office and open your spreadsheet document.
- 2. Select the target cells: Highlight the cells or columns where you want to store the 16-digit numbers.
- 3. Change format to Text: Go to the 'Home' tab, locate the Number Format drop-down menu in the ribbon, and select 'Text'.
- 4. Input the numbers securely: Type your long numbers. WPS Spreadsheet will preserve every digit exactly as entered.

Frequently Asked Questions
Why does Excel change the 16th digit of my number to zero?
Excel uses the IEEE 754 specification for storing floating-point numbers, which limits mathematical precision to 15 significant digits. Any digit past the 15th is automatically converted to zero to prevent calculation overflow.
Can I calculate 16-digit numbers if they are stored as text?
No, numbers stored as text cannot be used reliably in standard mathematical calculations. Attempting to multiply or add them may result in errors or force the spreadsheet to convert them back to 15-digit precision numbers.
Is there a keyboard shortcut to store a long number as text?
Yes, typing a single apostrophe (') at the beginning of your number tells the spreadsheet to treat the entry strictly as text. The apostrophe itself will remain hidden in the cell view.




