Paul Kraus wrote: > 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.
Put your numerics in quotes: "0099" But, depending on your copy of Excel, you may well not be able to do arithmetic on those fields. A CSV file simply doesn't hold any formatting information! Rob -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
