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