[treneryy]

I have a perl script that executes the stored proc in 10 different databases, puts results in excel file and emails it. the problem is that if value of the field starts with 0 it gets truncated in spreadsheet. I.e. 0098789 will be displayed as 98789.
Is the any way around it?

[reneeb]

I would recommend to use the Spreadsheet::WriteExcel-module. In this module a method, named set_num_format(), is implemented that meet your needs...

See: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.02/lib/Spreadsheet/WriteExcel.pm#set_num_format()