Internet and Excel Exponential download problem

myspace111

New Member
Joined
Oct 6, 2009
Messages
1
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” <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
When I click on it actually is “600107421338”<o:p></o:p>
But if I save this without converting it as above it is saved as is “600107000000”<o:p></o:p>
<o:p></o:p>
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.
<o:p></o:p>
Any idea, how I can get round this.
 

Dan Waterloo

Well-known Member
Joined
Jan 4, 2007
Messages
859
After downloading the data try formatting the cells with numbers in them as Number with no decimal places instead of General.
 

Forum statistics

Threads
1,082,569
Messages
5,366,360
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top