Datatext to columns, click next twice and under column data format select
date and YMD
then click finish.


--

Regards,

Peo Sjoblom


"Sandyw" wrote in message
...
I have a date entered as 20050103. How do I get it to change to 1/3/05?