Stop Long Numbers Turning into E+

Check pasted data or a spreadsheet for long numbers that Excel may display in scientific notation or store with lost digits.

Quick start

  1. Paste the column of long numbers.
  2. Check values at risk of scientific notation.
  3. Copy them in the text-safe format.

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.