Doug - Put a single quote just before the 0, like this:
"'04123","nextfield","more",etc. Excel will interpret the ' as an indicator that the field should be a text value and it will retain the 0 and left-align the value. Sami ----------------------------------------------------------- Sami Aaron Software Management Specialists 13214 W. 62nd Terr, #139 Shawnee KS 66216 913-915-1971 http://www.softwaremgmt.com ----- Original Message ----- From: "Doug Daily" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 11, 2002 5:13 PM 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/
