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
fficeffice" /><o
></o>
When I click on it actually is “600107421338”<o></o>
But if I save this without converting it as above it is saved as is “600107000000”<o></o>
<o></o>
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></o>
Any idea, how I can get round this.
When this ID is downloaded it appears like this “6.00107E+11” <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>When I click on it actually is “600107421338”<o
></o>But if I save this without converting it as above it is saved as is “600107000000”<o
></o><o
></o>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
></o>Any idea, how I can get round this.
