Last digits in a downloaded file are changed to zeros

[nikkilynn2]

I downloaded a file of USPS tracking numbers that are 22 digits long from a tracking website and I cannot see the entire tracking number. The numbers has been converted to Scientific, but when I change it to general, number or text, every number after the 15th digit is a zero. Is there a way to correct that so that I can view the correct tracking number?

 

[jtakw]

Hi,

You need to format your Excel cells as TEXT, before pasting in the tracking numbers.
Excel only handles up to 15 digits for Real Numbers.

 

[nikkilynn2]

Hi,
Thank you, but I am not pasting anything. I am opening a downloaded .csv file that contains the tracking numbers, but am unable to see the complete tracking number as they are 22 digits long. Is there a workaround for this?

 

[jtakw]

This may help, follow the instructions before opening your csv file.

How to Keep Leading Zeros in CSV

Microsoft Excel can use data produced by other computer applications that is saved in the text-based Comma-Separated Value file format. Excel knows how to convert the lines of comma-, space- or tab-separated information within CSV files into standard spreadsheet rows and columns. Excel may...

smallbusiness.chron.com

 

[jtakw]

Here's another that might be helpful:

How to avoid formatting change in CSV files in Excel

In this article, we are going to show you how to avoid formatting change in CSV files in Microsoft 365, Excel 2019, 2016, 2013 and 2010.

www.spreadsheetweb.com

 

[nikkilynn2]

Here's another that might be helpful:

How to avoid formatting change in CSV files in Excel

In this article, we are going to show you how to avoid formatting change in CSV files in Microsoft 365, Excel 2019, 2016, 2013 and 2010.

www.spreadsheetweb.com

Thank you so much!

 

[jtakw]

You're welcome, thanks for the feedback.