Hi, I am doing excel parsing with POI.
I have an excel cell where Formula is written. Formula is : =MROUND((IF(NZ38="","",NZ38+OB38)),TIME(0,10,0)). This shows data in cell like this : Mon 30/12 23:30 But I want the data in this format : 12/30/19 23:10 . I get this when I do Format cell > right click > Format Cell > Date > Type [ MM/DD/YY HH:MM ](24 hrs) How do I get the same by POI programmatically ? Thanks Shib
