Hello,

I am having an interesting issue with the cell data formatting. In the same column, i have dates being displayed in two formats:
  • format 1, e.g. 3/13/2008 (displayed on the left)
  • format 2, e.g. 2.12.2008 (displayed on the right)

The format 2 is a date format for sure. However, the format 1 appears to be in general format. When i try to convert from general to date format such as format 2. it does not work, it does show the format is now a date format, but data is still displayed on the left and with its original display (ex. 3/13/2008).
Of course by typing manually the date it works, but i have hundreds of lines in a similar state.

does someone know how to change format 1 cell into dates without having to update them manually ?
Many thanks in advance !
Antony