suppose u have value in cell A1 then put this formula in B1

=IF(LEN(A1)=8,LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,4),LEFT(A1,1)
&"/"&MID(A1,2,2)&"/"&RIGHT(A1,4))


On Nov 12, 2:02*pm, Sageman wrote:
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.