Data Import & Export

How to Stop Excel from Converting Tracking Numbers to Scientific Notation

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs a reliable method to import CSV files containing long FedEx tracking numbers into Excel without the numbers converting to scientific notation and losing digits.

Product: Excel
Device & OS: not provided
Scenario: Opening or importing a CSV data file containing tracking numbers that are longer than 15 characters.
Observed behavior: Excel automatically converts numbers exceeding 15 digits into scientific notation, irreversibly replacing any trailing digits with zeros and causing data loss upon opening.

Before you start

Do not double-click the CSV file to open it directly in Excel, as this immediately triggers the automatic number conversion and permanently truncates digits beyond the 15th character.

Solution 1Recommended

Import Data as Text Using the Text Import Wizard

The most effective way to keep long tracking numbers intact is to force Excel to treat the specific column as text during the import process by renaming the file extension.

Excel has a hard limit of 15 significant digits due to standard spreadsheet architecture. Any number exceeding this length is converted to scientific notation with trailing zeros. Formatting the cells as numbers after opening the file will not recover the lost digits, so the column must be defined as text before the data is loaded.

Rename the file extension

Locate your CSV file in File Explorer, right-click it, and rename the file extension from .csv to .txt.

Launch the import wizard

Open Excel, navigate to the File tab, select Open, and browse your computer to open the newly renamed .txt file.

Choose the delimiter

In the Text Import Wizard, select 'Delimited' on the first step and click Next. On the second step, check the box for 'Comma' as the delimiter and click Next.

Format column as text

In the Data Preview section of the third step, click on the column containing your tracking numbers to highlight it. Under 'Column data format', select 'Text', then click Finish.

Data Preservation: By formatting the column as text, Excel will display the tracking numbers exactly as they appear in the source file, preserving all characters.

Solution 2

Automate the Import Process with a VBA Macro

If you frequently work with CSV files containing long tracking numbers, a VBA macro can automatically prefix the numbers with an apostrophe during import, formatting them as text.

Free Microsoft Office alternative

Manage Complex Datasets Seamlessly with WPS Office

If you are frustrated by strict data conversion limitations in Microsoft Excel, WPS Office provides a free, lightweight, and highly compatible alternative for managing your spreadsheets. Easily control how your CSV data is imported and prevent unwanted formatting changes.

Fully compatible with Microsoft Excel formats (.xlsx, .csv, .xls).Intuitive Text Import features to safely handle long tracking numbers and barcodes.Free, lightweight, and fast-loading across Windows, Mac, and Linux.Familiar user interface requiring zero learning curve for Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change my 22-digit FedEx tracking number to letters and zeros?

Excel operates on the IEEE 754 specification, which has a maximum precision of 15 significant digits. Any number beyond 15 digits is converted to zeros, and the number is displayed in scientific notation (e.g., 1.23E+15) to save memory.

Can I fix the scientific notation by changing the cell format to Number?

No. If the CSV was opened directly by double-clicking, the digits beyond the 15th place have already been permanently replaced with zeros. You must re-import the original CSV using the Text Import Wizard to recover the full tracking number.

Is there a way to force Excel to stop converting data automatically?

In newer versions of Excel, you can go to File > Options > Data and disable automatic data conversions for leading zeros and long numbers. For older versions, you must manually use the Text Import Wizard or Power Query to define the column as text during import.

Excel & Data Problems