Stuart McLachlan
stuart at lexacorp.com.pg
Wed Feb 4 06:04:19 CST 2004
What format is the ID in your Access table? Does the number need to be treated as a number in Excel? If not, just leave the initial single quote there. On 4 Feb 2004 at 2:00, S D 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 -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.