Exporting issue with MS-access to MS-Excel 2003

[swenri]

I'm facing a strange exporting issue to MS-Excel 2003 using MS-Access 2000.I've a report developed using MS-Access.For some strange reason when ever I export the report which does have account numbers 0000E49921,0000E10563,0000E94230 it is not displaying these numbers to excel 2003 instead it shows as 0(zero).When I export the report to .html or .rtf or .txt the account number is displayed correctly. Can anyone throw light why this is happening ? Appreciate all help.

Thank you...

 

[missinglinq]

I never do this sort of thing, but it seems obvious from your description that the field you're importing your account numbers into, in Excel, is expecting a real number, not a value that includes an alpha character. 0000E49921 with its leading Zeros before the E is interpreted as Zero.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[SkipVought]

Hi,

This is an example of Excel trying to be helpful.

0000E49921 looks like scientific notation to Excel, so, naturally, Excel converts this string to a number.

Other similar examples include...
[tt]
9: is interpreted as TIME and so converted.
1/7 is interpreted as DATE and so converted.
[/tt]
To thewart this "helpfulness," prefix values in these columns with an APOSTROPHY, which will make Excel interpret as a LABLE which is TEXT.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}