On Tue, 2 Aug 2011, FranckF wrote:
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.
So in a cell you currently have a string like "2011-01-02", and you want to instead store a date? Simply grab the string, parse it to a DateFormatter to get the Date object, set that into the cell, and apply a suitable format.
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
