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