Why long numbers appear in E+ notation and lose digits in Excel: the 15-digit limit

E+ is scientific notation

1.23457E+15 is shorthand for 1.23457 × 10¹⁵. Excel may display long numbers this way under General formatting. If only the display changed, use Number formatting with zero decimal places to show the stored digits. This often affects account numbers, barcodes and order IDs with 13 to 16 digits.

Precision loss is a separate problem

Excel handles numeric values with only 15 significant decimal digits of precision. Entering a number with 16 or more digits, or reading one from CSV as numeric data, can replace later digits with zeros. Two different 16-digit IDs can become the same number. Once that happens, the original digits cannot be inferred.

Store long identifiers as text

Account numbers and barcodes are identifiers, not quantities for calculation. Prefix entries with an apostrophe or set imported columns to Text. For values already stored as numbers, check whether they exceed 15 digits. The Loopyti Prevent Excel Data Loss: CSV Value Check can locate risky cells containing long numeric strings.

Prevent Excel Data Loss: CSV Value Check