Hello. I am using Access to link to my accounting system table through an ODBC driver. I am just pulling a simple query of vendor name and number. I then copy and paste that information to Excel. I find that I am not able to use the vendor number in look up formulas unless I hit the edit function key for each vendor number cell. I seem to remember a trick involving a format chnnage and then an import/export with Access again but I cannot get it to work. Hitting F2-Enter 3,000 times gets old fast. Can anyone please tell me what I need to do in order to get the vendor number field to copy out properl;y as a number? Thank you
Jeff
