Thanks Nick for quick answer. Maybe I was not so clear. I have at the begining a string value "" that I would like to convert in a real excel Date format but I don't want to keep in the cell DATEVALUE(). So getting the string value of my date and give it to DATEVALUE is working very well and when you open excel sheet you can see real date. My problem is that I still have in cell the formula. So I wanted to evaluate this formula in place of keeping it and at the end I have in my xls all date in text replaced with actual excel date.
But maybe I should go a different way and just change the format. I'm new with POI. Cheers Franck -- View this message in context: http://apache-poi.1045710.n5.nabble.com/HSSFFormulaEvaluator-DATEVALUE-is-not-evaluated-tp4658681p4658860.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
