Change format of a date field
I have been given a csv file - on opening in excel the dates are in the
format 25051917, 5051949, 23121979 etc.
I have been struggling to get them into the standard date format - in this
case 25/05/1917, 05/05/1949, 23/12/1979 etc. Any help appreciated.
|