Change date

Q

Quandary

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.
 
R

Ron Rosenfeld

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.
Click to expand...

Select your column of dates.

Then:

Data/Text to Columns
Next
Next
Column Data Format Date:YMD
Finish


--ron
 
G

Gord Dibben

Select the column of dates.

Data>Text to Columns>Next>Next. Format data type>Date>YMD and Finish.


Gord Dibben Excel MVP
 
Top