Large Numbers

[ehrimat]

Hello Everyone,

I use a certain package tracking software that allows me to export the tracking information into CSV format. The software does not yield any other options, one button that says "CSV Export"

When I open the file in Excel, the numbers that are 15 digits are formatted with a scientific notation ex:4.34E+11
From reading some of the posts, I understand that Excel can only handle a certain amount of digits as number. Also, in order to view large number I have to format the cell into text.
After I open the CSV file and change the cell format into text, some of the digits remain abbreviated while some need to be double clicked in order for the entire number to show.
I tried to rename the file as .txt I also tried to import the file into Access but neither worked for me.

My question is; is there a way, method, code that can help me maintain the full number.

Thank you kindly,

 

[RonB1111]

Try selecting all cells with scientific notation and change the format to "number" (eg: click the comma (,) icon in the upper area of your spreadsheet)

 

[pgc01]

Hi
Welcome to the board

Have any of the numbers more than 15 digits?

 

[ehrimat]

Here is a USPS tracking # 9101150134811209669286 and the way it appears is 9.10115E+21


Kind Regards,

 

[ehrimat]

Try selecting all cells with scientific notation and change the format to "number" (eg: click the comma (,) icon in the upper area of your spreadsheet)

Thank you for the reply,

If I did that and used the comma the result will be the following:


9,101,150,134,811,200,000,000.00

instead of

9101150134811209669286

Thank you,

 

[RonB1111]

Right click "Format Cells" and select "Number" and change decimals from 2 to 0 and uncheck the box next to "Use 1000 Separator(,)".

Unfortunately, anything beyond 15 positions is not coming thru as a number. The only way I know how to get a number to display more than 15 positions is to import it (or format it) as "Text.

 

[pgc01]

Here is a USPS tracking # 9101150134811209669286 and the way it appears is 9.10115E+21

In this case, you have to import it as text.

I tried to rename the file as .txt I also tried to import the file into Access but neither worked for me.

... but that's the way to do it. Rename the file as .txt and open it in excel. You are taken to the text import wizard. In the last panel, when you see the columns with a preview of the data, click on the header of the column with those numbers (the column is selected) and check the Text option button. This will import the numbers as text and you won't lose digits.

 

[ehrimat]

Thanks a million, I will give it another shot and will let you know.