Calculation Issues

How to Store and Calculate 16-Digit Numbers in Excel

John WilsonJohn Wilson Oct 29, 2026 871 views

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.

How to Store and Calculate 16-Digit Numbers in Excel Without Precision Loss
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the target area

Highlight the empty cells or entire columns where you plan to input your 16-digit numbers.

2
Open Format Cells

Right-click the selected area and choose 'Format Cells' from the context menu to open the formatting dialog.

3
Apply Text formatting

Navigate to the 'Number' tab, select 'Text' from the Category list on the left, and click 'OK'.

4
Enter your data

Type your 16-digit numbers into the newly formatted cells. Excel will now preserve every digit exactly as you typed it.

Format Cells as Text to Safely Store Identifiers
Quick Entry Shortcut: If you only have a few numbers to enter, you can type a single apostrophe (') before the number (e.g., '1234567890123456). Excel will instantly treat the cell as text and hide the apostrophe.
Efficient Spreadsheet Tool

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. 1. Open your workbook: Launch WPS Office and open your spreadsheet document.
  2. 2. Select the target cells: Highlight the cells or columns where you want to store the 16-digit numbers.
  3. 3. Change format to Text: Go to the 'Home' tab, locate the Number Format drop-down menu in the ribbon, and select 'Text'.
  4. 4. Input the numbers securely: Type your long numbers. WPS Spreadsheet will preserve every digit exactly as entered.
100% compatibility with Microsoft Excel (.xlsx, .xls, .csv) formatsQuick and intuitive cell formatting tools for large datasetsFree to download and use for your daily spreadsheet tasks
microsoft office alternative - wps office

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.