Hopefully Jan 1 2005 will come in as 20050101XXXXXX, if not this won't
work:
First select the column with the dates, then do datatext to column,
select fixed width and click next, click between the last day digit
(your example after 6)
click next, select the right hand column with 000001 and click do not
import (skip), select the left hand column and under column data format
click Date and YMD
click finish Returns 11/26/2004 for me


Regards,

Peo Sjoblom