Quickly typing dates into cells

**RonG** · 05-23-2005, 02:56 PM

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?

**olasa** · 05-23-2005, 03:17 PM

I presume that 051505 is entered as a Number? So it becomes 51505 --> LEFT(A1,2)=51 ... see the problem?
But if you enter '051505 it will work, or it you Format the cell as Text, then enters 051505 it will stay 051505 and the formula will work

Ola