poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Beardsley <markbrd...@tiscali.co.uk>
Subject Re: Generating excel file with dates prior to 1900
Date Fri, 13 Sep 2013 06:50:04 GMT
You are not missing anything because - and this is the short answer - Excel
treats any date prior to the epoch (1/1/1900) as text.

The only option you have is to code some VBA support for earlier dates or to
use an add-on pack if one is even available. Take a look here to get started
with this issue; http://support.microsoft.com/kb/245104



--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Generating-excel-file-with-dates-prior-to-1900-tp5713750p5713751.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message