Select that range in the column
data|Text to columns
fixed width (but remove any lines that excel guessed)
make sure you choose YMD as the date type



Quandary wrote:

I have a rather large list of dates that are in a column and are written
first as year then month then day Ex: 20051116. I want to change all of them
in a date format like this 11/16/2005 with out retyping each one. I have
tried to change the format but excel will not read it. I have tried to make a
macro but excel only changed that one cell not the entire column. Please
help.

--

Dave Peterson