Hi,

Try this then format as required

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

Mike

"pgarcia" wrote:

How can I fix this? I had used a formula years back but can't remmeber how it
goes. Thanks

=DATE(right(A1,2),mid(a1,5,2),left(A1,4))

but it does not work.

Thanks