As long as you have 2 digits for months and days,
select the column, do datatext to columns, click next twice,
under column data format select date and then select YMD
assuming that is the order of the original. Then it will retrun a date based
on your regional setting so if in US you should get MDY

--

Regards,

Peo Sjoblom

"Rose" wrote in message
...
Can I change a date with no format ex: 20051111 to a date format ex:
11/11/2005?