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,
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,