in reply to Changing time & date format

I suspect that the format is Excels internal format, which is described in the Spreadsheet::WriteExcel documentaiton. You can use Spreadsheet::WriteExcel::Utility to convert it into a unix timestamp. Once you have it in that format, localtime and POSIX::strftime should do the trick.