Formatting Issues

How to Format FedEx and UPS Tracking Numbers in Excel Without Losing Zeros

Kushani NimanthikaKushani Nimanthika Oct 29, 2026 871 views

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.

How to Format FedEx and UPS Tracking Numbers in Excel
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 you start

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.

Solution 1Recommended

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.

1
Highlight the target cells

Select the specific cell, range, or entire column where you plan to enter the FedEx or UPS tracking numbers.

2
Open the Format Cells dialog

Right-click the selected area and choose 'Format Cells' from the context menu, or press the 'Ctrl + 1' keyboard shortcut.

3
Apply the Text format

In the 'Number' tab, select 'Text' from the Category list and click 'OK'.

4
Enter the tracking numbers

Type or paste your FedEx or UPS tracking numbers into the pre-formatted cells. Excel will now preserve all leading and trailing zeros.

Pre-format the Cells as Text
Green Triangle Indicator: You may see a small green triangle in the corner of the cell warning you about a 'Number Stored as Text'. You can safely ignore this or choose 'Ignore Error' from the warning dropdown.
Efficient Spreadsheet Tool

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. 1. Open your logistics document: Launch WPS Office and open your shipping or logistics tracking spreadsheet.
  2. 2. Select the tracking column: Highlight the entire column designated for your FedEx or UPS tracking numbers.
  3. 3. Change format to Text: Right-click the highlighted column, choose 'Format Cells', select the 'Text' category, and click 'OK'.
  4. 4. Paste your data securely: Paste your tracking numbers into the column. WPS Spreadsheet will perfectly preserve every digit without any automated conversions.
Keep leading zeros intact by quickly converting cell formats to Text.Fully compatible with Microsoft Excel (.xlsx) file formats.Lightweight software with a highly familiar user interface for smooth data entry.Built-in data validation to ensure accurate tracking number lengths.
microsoft office alternative - wps office

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.