Excel turns barcodes and long IDs into 8.71E+12 — how to keep them intact
Why EAN codes, order numbers and IBAN-like values break in Excel and how to prevent it.
The message you see
Numbers show as 8.71E+12 in ExcelFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- Excel stores numbers with 15 significant digits; longer values lose their last digits.
- Opening a CSV by double-click lets Excel convert text columns to numbers.
How to fix it
- 1Import via Data → From Text/CSV and set the column type to Text.
- 2Never save the CSV again after Excel converted it — digits lost after 15 can't be recovered.
- 3Convert the CSV to XLSX with text preserved, then work in that file.
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support