If you rename the file to a .TXT extension then open it Execel will give you the option to set the importing rules. you can then change the first column to a text input by right clicking on the column header
Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WiTangoGoodies.htm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Doug Daily Sent: Monday, February 11, 2002 3:13 PM To: [EMAIL PROTECTED] Subject: Exporting to Excel I've got Sami's email on how to output an excel file with a headings row, but my first column is a budget number, 04123, which Excel imports and makes a general number of: 4123. The leading zero is significant. Any way to make Excel import it as text? In the CSV file, that field has the quotes: "04123","nextfield","more",etc. Thanks. Douglas Daily Payroll Manager Facilities Services, box 352215 206-221-4357 ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
