Keith Williamson
kwilliam at ashlandnet.com
Wed Jun 23 09:02:54 CDT 2004
Thanks, guys. I should have thought of that. I must be getting old. :) Regards, Keith E. Williamson Ashland Equipment, Inc phone # (410) 273-1856 fax # (410) 273-1859 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Wednesday, June 23, 2004 9:40 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Access Export to Excel Keith, In my experience, the only way to ensure the "number" remains "text" in Excel is to prepend with an apostrophe ( ' ). Also the first data element in the column determines the format for the entire column. Prior to your export you'll need to add the apostrophe. It won't show in Excel. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Keith Williamson Sent: Wednesday, June 23, 2004 7:35 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Access Export to Excel Hi all; I'm sure this is an easy one, but.....I have a report that I am trying to export to Excel. One of the fields is a text field (example: "0032", as text). When it exports to excel, it winds up truncating off the zeros, to become "32", instead. I really need this field to remain "0032". Any ideas? Thanks in advance. Keith E. Williamson Ashland Equipment, Inc phone # (410) 273-1856 fax # (410) 273-1859 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com