I am using formula =DATEVALUE(LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,2)).

When value in A1 = 121505 (six digit number) - formula returns 12/15/05.

When value in A1= 051505 or 51505 - formula returns #VALUE error.

What am I doing wrong, please?