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.
-----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> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
