Hi,

You can also try this. Highlight the range and go to Data Text to
columns. While on Delimited, click on next twice and then select Date in
Column Date format. Select DMY in the drop down and select any blank cell
in destination. Click on Finish. This should get the dates in the required
format. Please note that this will not give you the correct result for
5051949. To make this work, you will have to precede 5051949 with
05051949.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sageman" wrote in message
...
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.