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.