If your data is in A1, try

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

then format the cell as d/m/yyyy


"Tom" wrote:

I'm sure this question has been asked before.
How to convert the date expressed as "20061215" to read as 15/12/2006?
Thanks for your help.

Tom