S D
accessd667 at yahoo.com
Wed Feb 4 08:07:23 CST 2004
Hi group, thnx for all tips/tricks/idea's. I've implemented a workaround using a csv file. The user imports this into Excel. Works like a charm. SD S D <accessd667 at yahoo.com> wrote: 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 --------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!