I don't know whether or how you could automatically identify it as a date. When outputting dates to Excel in PHP, I store the serial date and apply a date format. I've not used the equivalent in Perl yet (edited to add: and you're doing input, not output) so can't tell you "just do this and this and Bob's your uncle." I'd be interested in knowing what you find out.