Yes, if all of your data is like this in the list, there's a little bit of
work you need to do:

First, insert three columns next to your date column and do "Data Text to
Columns" using Fixed Width, and put your lines after 2006 and 06 so that the
data is divided like this: 2006|06|25

Then in the blank cell next to your separated data, concatenate the
separated cells back together so that they dispay as 06/25/2006.

Format this column as a Date in the format you want it to display.

Finally, do a Text to Columns again, use Delimited, but make sure to remove
any checkmarks from the delimiters before clicking finish. This will
finalize the field as a date and fix your problem.

Yes, I've had to do this a couple of times myself. :)

Let me know if you have any problems!

"Fam via OfficeKB.com" wrote:

can date 20060625 be converted into 06/25/2006?
Any help will be appreciated.
Thx

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1