$worksheet->write_number( $row, $col, sprintf ('%d',$data{'Peak_MO'}), $number); $worksheet->write( $row, $col, sprintf ('%d',$data{'Peak_MO'}), $number); #### my $number = $workbook->add_format( font => 'Arial', border => 1, size => 10, align => 'center', valign => 'vcenter', italic => '1', );