Change date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Select the column of dates.

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


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Remove date format? 3
Date changes in data 1
Date Formatting 2
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
retain custom date format "text" when pasting or reformatting data 2
Need help with access expression - HELP!! 0
Date Format not working 2

Back
Top