ahhh.. thanks. -----Original Message----- From: Eric Hsiung [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 June 2003 9:53 PM To: 'POI Users List' Subject: RE: Dates, Dates and more dates.
>Turns out the dates I was using in my application were all > set to the last > millisecond of the day eg 23:59:59:999. Looks like excel was > rounding this > value up to the nearest second, thus pushing the value > displayed in the cell > to the next day. I think (although my understanding of excel > is limited) > this would be due to the fact that excel understands only > hours, minutes and > seconds? > > george Excel can display up to milliseconds but you'll have to specify a custom format of "m/d/yyyy h:mm:ss.00". Alas, you cannot do this via POI since custom formats are not available. :-( Eric --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
