in reply to parse Excel number which represents a date

That is how Excel represents dates. See Spreadsheet::ParseExcel for the routines that convert from numbers to formatted strings or just use the formatted value instead of the raw value. Maybe also consider Spreadsheet::ParseXLSX, which is more recent.

  • Comment on Re: parse Excel number which represents a date

Replies are listed 'Best First'.
Re^2: parse Excel number which represents a date
by fionbarr (Friar) on Aug 28, 2015 at 15:45 UTC
    Success with 'Spreadsheet::ParseXLSX'. Thanks to Corion and others who suggested possibilities.