Hi,

Try entering the following formula.

=DATE(RIGHT(A6,4),MID(A6,4,2),LEFT(A6,2))

and apply a custom format to the cell of dd-mm-yyyy

It works by extracting the digits for the year, month and date.

Dave

url:http://www.ureader.com/msg/104234314.aspx