my $dateformat = $workbook->add_format(num_format => ~'mm/dd/yyyy~') #### my $dateformat = $workbook->add_format(num_format => 'mm/dd/yy')