convert Numbers to Dates

[Hardeep kanwar]

Is it Possible to Convert Mentioned Below Number to Dates

In mm-dd-yyyy Format

Dates
29082009
31082009
05092009
07092009
08092009
09092009
07112009
25082009
11092009
08092586
08092586
09082009
27082009
27082009
27082009
29082009
31082009
24104889
05092009
10092009
09032009
09052009
09092009
25082009
26082009
29082009
29082009
29082009
24104889
24104889
21097627
07092009
12092009
14092009
14092009
14092009
28082009
08092009
29082009
31082009
08092586
08092586
28102668
09032009
09042009
09092009
09092009
09102009
09102009
09112009
09112009
08092586
12062641
28102668
28102668
18122750
09022009
09022009
09032009
05052009
15032696
18122750
09032009
09042009
9122009
7092009
12092009
12092009
14092009
25--08-09
25--08-09
25--08-09
25--08-09
28--08-09
29--08-09
29--08-09
24104889
24104889
21097627
21097627
3092009
5092009
5092009
5092009
7092009
7092009
7092009
7092009
7092009
8092009
8092009
8092009
8092009
9092009
9092009
9092009
10092009
10092009
11092009
11092009
11092009
12092009
14092009
12062641
9092009
16102285
28082009
24104889
25082009
29082009
4092009
9092009
11092009
12092009
12092009
14092009
14092009
28072009
27072009
4082009
26082009
31082009
11092009
12092009
25082009
29082009
31082009
5th sept 09
14092009
9112009
29082009
9012009
9052009
9102009
9102009
9102009
14092009
14092009
25082009
26082009
26082009
29082009
31082009
9042009
9042009
9052009
9072009
9092009
14092009
14092009
14092009
14092009
18122750
09032009
26082009
27082009
19052009
06042009
06072009
19062009
22062011
29062009
29062009
07032009
07082009
13072009
14072009
15072009
20072009
23072009
26072009
26072009
26072009
28072009
28072009
28072009
28072009
29072009
31072009
08022009
08022009
08042009
08072009
08122009
14082009
14082009
17082009
20082009
29088219
25082009
26082009
28082009
30082009
31082009
31082009
09072009
09072009
09072009
09092009
14092009

 

[Luke M]

Either:
=DATE(RIGHT(A2,4),MID(A2,3,2),LEFT(A2,2))
and custom format cell as mm-dd-yyyy

or

=TEXT(DATE(RIGHT(A2,4),MID(A2,3,2),LEFT(A2,2)),"mm-dd-yyyy")

Note that the former has the advantage of that it remains a number (easy to
compare, and my preferred method of handling dates)

 

[Gary''s Student]

=DATE(RIGHT(A1,4),LEFT(RIGHT(A1,6),2),LEFT(TEXT(A1,"00000000"),2))
with the proper format.

 

[Hardeep kanwar]

Man you both are Life Saver

Thanks Both of you

Regards

Hardeep kanwar