in reply to Need help in Excel::Writer::XLSX

Please read the section in Excel::Writer::XLSX on formats. Especially the method ->set_num_format().

In Section Seekers of Perl Wisdom