date is in 20010129 format, how can I get it in m/d/y format

[jsanders]

--
jsanders

[Peo Sjoblom]

Data>text to column, go to step three and select date and YMD

and for future posts it's considered rude just using the subject line


Regards,

Peo Sjoblom

[Dave O]

With the value 20010129 in cell A1, enter this formula in B1:
=DATEVALUE(MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4))

and the format the cell as a date. The various functions parse the
20010129 string into its components, and the DATEVALUE converts that
string to a datevalue that Excel can recognize.