Hi,
I am having an issue importing data from a mysql database. I am using long numbers as identifiers. When exporting the numbers into excel they are truncated.

ie

before export 10002476854611180001

When it is exported it shows up as 1.00025E+19 and when I format it translates it to 10002476854611200000. So it appears to be rounding it after the 14th digit. Is there anyway to keep this from happening ? some kind of setting in excel 07?

Regards,
JKZfixme