Converting date format in Excel

[XrayVision]

I have column a with the dates in this format:
19990527 (yyyymmdd)I would like to convert them to:
05/27/1999 in column b. Could someone post a formula or routine that would parse col a?

Thanks a bunch

 

[bluedragon2]

Assuming date is in cell A!:

=RIGHT(A1,2)&"/"&MID(A1,4,2)&"/"&LEFT(A1,4)

 

[bluedragon2]

opps:

=RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)

 

[bluedragon2]

lets try this again :

=MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4)

 

[bluedragon2]

Now you can format column B for date mm/dd/yyyy

and do:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))