[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!