At 02:03 PM 12/12/2003, Tim Johnson wrote: >I think this is more an Excel question than a Perl question. Excel will >detect that it is a number and show you the equivalent formatted as a >number. I think you can highlight the row and do a Format->Cells and >pick Text as the type. Otherwise if the first character is a single >quote then excel will treat the cell as text.
This doesn't work for me, the single quote is picked up in the conversion process. I don't think it is possible. -Mark >-----Original Message----- >From: Paul Kraus [mailto:[EMAIL PROTECTED] >Sent: Friday, December 12, 2003 12:49 PM >To: [EMAIL PROTECTED] >Subject: CSV file - Leading Zeros > >Is there a way to write a CSV file so that excel wont drop the leading >zero's from fields? I could use spreadsheet::writeexcel or OLE but >that's like using a sledgehammer for something that needs to be hand >tightened. > >Thanks. >Paul -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
