Why Excel turns long numbers into 1E+15
If an order number like 1234567890123456789 shows up in Excel as 1.23457E+18, or its last digits are all zeros, Excel treated it as a number and kept only the first 15 significant digits.
What Excel actually stores
Excel stores numbers as double-precision floating point values, which hold about 15 significant digits. Anything longer is rounded: 1234567890123456789 becomes 1234567890123460000. Long account IDs, tracking numbers, card-style numbers and some database keys all exceed this limit.
The damage cannot be undone in Excel
Once Excel has rounded the value, the original digits are gone. Changing the column to Text afterwards only locks in the already-wrong number, so you must go back to the original CSV.
How to prevent it
- Use Data > From Text/CSV and choose “Do not detect data types”, or set those columns to Text in the preview.
- Format destination columns as Text before pasting data in.
- Watch shorter IDs too: 12 to 15 digits are kept exactly but often display as
1.23E+11in narrow columns. - Run the file through KeepLeadingZeros.com, which flags long numeric strings and exports them as text cells.
A similar trap: 1E5
A value such as 1E5 is read as scientific notation and becomes 100000. If it is really a product code, it needs to be stored as text.