A tracking number changed to 1.23E+12 and its last digits became zero
Check pasted data or a spreadsheet for long numbers that Excel may display in scientific notation or store with lost digits. Export risky values as text.
How to use it
- Paste a table or upload a CSV, TSV, or XLSX file.
- Choose the delimiter, header option, and worksheet if needed.
- Review the flagged values and download an XLSX that stores selected columns as text.
Keep long IDs and tracking numbers intact in Excel
Spreadsheet programs may display long numbers in scientific notation and preserve only 15 significant digits in numeric cells. Leading zeros can also disappear.
Check identifiers before opening or editing a source file. Exporting the received value as text protects it going forward, but it cannot restore digits that were already lost.
A value that looks shortened may only be formatted differently, or it may have lost precision. Compare it with the original source to tell which happened.
What this helps with
- Changing a cell to Text after Excel already read it as a number → Check risky values before they are changed.
- Adding an apostrophe to cells one at a time → Export selected columns as text together.
- Importing a CSV and setting each column manually → Review risky values before saving.
Limitations
- Lost digits in a number already converted to scientific notation cannot be recovered; download the original again.
- Whether a value was only reformatted or actually changed must be checked against the source.
- Formula results become saved values, and workbook formatting, charts, merged cells, and other sheets may not be preserved.