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

E

Eqa

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
 
R

RichardSchollar

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
 
E

Eqa

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