Internet and Excel Exponential download problem

Question

I daily download a file from a client’s web site, one of the fields that I download is read into Excel as numbers, and when this number is very large the number appears in Excel as Exponential. Example

When this ID is downloaded it appears like this “6.00107E+11”

                                                 When I click on it actually is “600107421338”

                        But if I save this without converting it as above it is saved as  is “600107000000”

 

 When I try and read this number it last few digits of the number appear as “0”, I know they are not, because if I open the file as read and read and convert these numbers to text then click on the field they appear as numbers and full numbers.

 

Any idea,  how I can get round this.

Answer 1

You would probably have better luck posting in an Excel forum.  But I pasted this number into Excel 2007 and it saved and reopened ok without the trailing zeros.

Jeff Dillon, adCenter API Support

Answer 2

Thank you Jeff for your replay,
I will try and post this into Excel the  forum, although I think it is a an operating system issue, or internet setup issue, but not sure how to resolve it.
The download is saved as .csv file from the internet, so if I open it in .cvs as mentioned, I have to go through the steps mentioned above to get the right ID.  Even if I import the .csv directly into access I get the same issue, the ID is truncated and is not the right ID.