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.
|
|---|
| 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 |