How to Format FedEx and UPS Tracking Numbers in Excel Without Losing Zeros
Question details
The user needs to enter long FedEx or UPS tracking numbers into Excel without the software automatically deleting leading or trailing zeros or converting them to scientific notation.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Entering or pasting logistics and shipping tracking numbers into a spreadsheet for record-keeping.
- Observed behavior
- Excel automatically removes leading and trailing zeros or alters long numeric strings into scientific notation, corrupting the actual tracking numbers.
Before typing or pasting your logistics data, verify exactly which columns will contain the FedEx or UPS tracking numbers so you can apply the correct formatting rules to those specific areas beforehand.
Pre-format the Cells as Text
Converting the cell formatting to Text before entering the data is the most reliable way to prevent Excel from changing your tracking numbers.
By default, Excel treats all inputs containing only digits as numbers. Since tracking numbers often exceed 11 digits and can contain leading zeros, applying a Text format tells Excel to treat the sequence exactly as typed.
Select the specific cell, range, or entire column where you plan to enter the FedEx or UPS tracking numbers.
Right-click the selected area and choose 'Format Cells' from the context menu, or press the 'Ctrl + 1' keyboard shortcut.
In the 'Number' tab, select 'Text' from the Category list and click 'OK'.
Type or paste your FedEx or UPS tracking numbers into the pre-formatted cells. Excel will now preserve all leading and trailing zeros.

Prefix the Value with an Apostrophe
If you are only entering a few tracking numbers manually, you can use a quick typing trick to force Excel to store the number as text.
Format Tracking Numbers Easily with WPS Spreadsheet
WPS Spreadsheet allows you to seamlessly manage logistics data, format long tracking numbers as text, and avoid scientific notation errors for free.
- 1. Open your logistics document: Launch WPS Office and open your shipping or logistics tracking spreadsheet.
- 2. Select the tracking column: Highlight the entire column designated for your FedEx or UPS tracking numbers.
- 3. Change format to Text: Right-click the highlighted column, choose 'Format Cells', select the 'Text' category, and click 'OK'.
- 4. Paste your data securely: Paste your tracking numbers into the column. WPS Spreadsheet will perfectly preserve every digit without any automated conversions.

Frequently Asked Questions
Why does Excel change my long tracking numbers to scientific notation?
By default, Excel applies a 'General' number format. If a numeric entry contains more than 11 digits, Excel automatically converts it into scientific notation (e.g., 1.23E+14) to save visual space in the cell.
Can I use custom number formatting to restore missing zeros?
While you can use Custom formatting (like typing a string of 0s) to visually display missing leading zeros, this only changes how the number looks, not the underlying data. For tracking numbers, it is much safer to format them strictly as Text to preserve the actual exact characters.
How do I fix tracking numbers that already lost their leading zeros?
Once Excel processes the number and drops the leading zeros, the original data in that cell is permanently altered. You must first format the blank destination column as Text, and then re-paste or re-import the original data from your source document.
Is it possible to add spaces between every four digits of a tracking number?
Yes. Once your complete tracking number is safely stored as text, you can use text manipulation functions like the MID function to format the output with spaces. However, the foundational step must always be preserving the full continuous text string first.




