Add / in between numbers

[tek9step]

I would like to add "/" in between numbers in order to formulate it as a date.

e.g

11010 ==> 01/10/2010
121010 ===> 12/10/2010

I have tried using =REPLACE(A21,2,0,"/") but cant do more than one. thanks

[daddylonglegs]

Try this to convert to a date

=TEXT(A21,"00-00-00")+0

format in required date format

[tek9step]

Brilliant DLL Thanks