Maybe a formula of

=DATE(RIGHT(A1,4),MID(A1,LEN(A1)-5,2),LEFT(A1,LEN(A1)-6))


--
__________________________________
HTH

Bob

"Robin Gray" wrote in message
et...
I have a csv file which when opened with excel shows dates as 15041978 or
4051949. I am struggling to convert these to the normal format
15/04/1978 or 04/05/1949.
Any suggestions.

TIA