=DATE(RIGHT(A1,2)+2000,LEFT(A1,LEN(A1)-4),MID(A1,LEN(A1)-3,2))

But depending on what position you assume the month to be, you might have to
switch 2nd and 3rd argument. It is now set op so that 60306 means 3rd of
June 2006

--
Kind regards,

Niek Otten

"Adam" wrote in message
...
i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006.

nOT SURE HOW TO DO IT THANKS

ADAM