Dates that need to be split into Year/MM/DD

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

Guest

I have a long list of dates in a column that are YYYYMMDD without any / or -
to break up the year, month,day How do I insert these breaks automatically?
Cell formating by date doesn't give me the the correct format. Thanks
 
Hi Eqa

Select the column, and go Data>TextToColumns. Hit Next, Next and on
the third screen, on the right hand side, choose a Date Format of YMD
and click Finish. Hopefully this will correctly convert them.

An alternative formula approach would be:

=TEXT(A1,"0000-00-00")+0

copied down, but TextToColumns is easier.

Hope this helps!

Richard
 
Thanks Richard. Very helpful.

RichardSchollar said:
Hi Eqa

Select the column, and go Data>TextToColumns. Hit Next, Next and on
the third screen, on the right hand side, choose a Date Format of YMD
and click Finish. Hopefully this will correctly convert them.

An alternative formula approach would be:

=TEXT(A1,"0000-00-00")+0

copied down, but TextToColumns is easier.

Hope this helps!

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

Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Changing date to eliminate day in format mm/dd/yyyy 1
change DD/MM/YY to MM/DD/YY 6
Change from mm/dd/yy to yy/mm> 3
Convert text date to mmddyyy date 2
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
how do i split a cell that contains dd/mm/yy into a 3 separate cel 2

Back
Top