I'm reading an Excel 2007 file, modify some values and then save it to a new file.
I have a column full of dates in the dd/mm/yyyy format (17/03/2009) and write in the next column dates in the same format.
Once I'm done, I open my previously saved file with Excel 2007.
My problem is that all the dates are now in the mm-dd-yyyy (03-17-2009) format. Even the ones I didn't write.
How do I keep the original format of the dates (dd/mm/yyyy) ?