[AccessD] Export to Excel URGENT!

Jim Hewson JHewson at karta.com
Wed Feb 4 07:41:48 CST 2004


Excel is treating formatting the number in scientific notation.
Check the format of the ID number when exporting.
HTH
Jim


-----Original Message-----
From: S D [mailto:accessd667 at yahoo.com]
Sent: Wednesday, February 04, 2004 4:01 AM
To: accessd
Subject: [AccessD] Export to Excel URGENT!


Hi group,
 
i've got a big problem. I exporting 18 digit numbers to Excel.
Like 123456789012345678. This is an ID. 
The ID's are copied to Excel. When I open Excel I see numbers like:8.72E+17

I've tried reformating the column/row to TEXT but it didn't work. When I
directly type the number into Excel it works. The 18 digit number doesn't
reformat. When I export it to Excel using a ' (quote?) sign and then
manually remove the ' it also works. When i use Find & replace the number is
reformatted to 8.72E+17?!

Please help me with this one.

Sander

PS: I'm exporting thousands of ID's every 5 minutes....I do NOT want to
suggest "Do it manually" 


---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list