Text to Date Formatting

I have been trying to wrap my head around this one for a while.
From To
21016 10/16/2002
21017 10/17/2002

in other words
ASDHK to SD/HK/200A

This is a huge problem and I thank any contributors ahead of time.

Using formulas, if your Data is in A1, you can type the following into A2:

Please Login or Register  to view this content.

Hi and welcome to the board

what happens if your string is for, say 1999 or 2010 ?

Fizziii, you rock, that was a perfect answer to that problem,
I have two more
like arthurbr said, in my date convention a 1999 code is
991031
which would be converted to 10/31/1999
another one of mine is
1201
which would need to be converted to 12/01/2001
and 301
which would be converted to 03/01/2001

thanks again, Fizziii
-slug

Ok, so for the 1999 one:
code:
=MID(A1,3,2) & "/" & MID(A1,5,2) & "/19" & LEFT(A1,2)