Re: Creating Excel file using Perl

Hello Rahul

Try changing

my $dateformat = $workbook->add_format(num_format => ~'mm/dd/yyyy~')
[download]

my $dateformat = $workbook->add_format(num_format => 'mm/dd/yy')
[download]

It might be easier for us to investigate and provide further assistance if you posted more of your code..

Comment on Re: Creating Excel file using Perl Select or Download Code

Replies are listed 'Best First'.
Re^2: Creating Excel file using Perl by Rahul Saxena (Initiate) on Oct 21, 2015 at 04:11 UTC
Hello shadowsong, I have tried what you suggested, but format in excel for date values is still showing "custom". how can I display date values in 'date' format in excel. Please help me.	[reply]


good chemistry is complicated, and a little bit messy -LW
	PerlMonks