A tracking number changed to 1.23E+12 and its last digits became zero

Built!

Check pasted data or a spreadsheet for long numbers that Excel may display in scientific notation or store with lost digits, and keep them as text.

Current workflow

Paste a 13-digit tracking number, an EAN-13 barcode, or a 16-digit card number into Excel, and it turns into scientific notation like 1.23457E+12. People try to prevent this by setting cell format to Text, adding an apostrophe (') in front of each value one cell at a time, or specifying Text for each column during CSV import. Timing is the catch: changing the format to Text after Excel has already read the value as a number won't bring back anything past 15 digits. If only the display changed to scientific notation, fixing the format restores the full number — but if Excel stored the value as a number and zeroed out the digits beyond 15, those digits are gone, because 15 is the limit of Excel's numeric precision.

Solution

Stop Long Numbers Turning into E+

How to use

1. Paste the column containing long numbers (tracking numbers, barcodes, card numbers, and so on). 2. In the check results, see which values are at risk of scientific notation and which ones already display incorrectly. 3. Copy the text-locked format and paste it into Excel to keep every digit. There's no need to add ' cell by cell. You can also save the risky columns as a text-formatted XLSX. 4. Digits already lost to zeros can't be recovered. Get those numbers again from the source system (your order or shipping system).

Example

- Input: a column of 16-digit ID numbers - Result: the check separates values that would display as 1.23E+15 with trailing digits zeroed in a number cell from values that keep all digits in a text cell — so a display issue and actual data loss are clearly distinguished.

Open tool
View details
Limits
- Telling a display-only change apart from real loss requires knowing the original number of digits. - Long numbers produced by formulas can stop calculating when converted to text. Keep value columns and formula columns separate.
Cost type
Free

Digits that have already been turned into zeros can't be recovered by any tool. If a CSV was saved over in a state like 1.23E+15, the information left in the file itself has already been replaced with zeros. The only fix is to pull the number again from the source system (your order or shipping system). That's why this check is about prevention, not recovery: check the risky values before pasting long-number columns, and paste using a text-locked format for the whole column.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in