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

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

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

Hi Eqa

Select the column, and go DataTextToColumns. 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


On 20 Mar, 08:36, Eqa wrote:
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

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

Thanks Richard. Very helpful.

"RichardSchollar" wrote:

Hi Eqa

Select the column, and go DataTextToColumns. 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


On 20 Mar, 08:36, Eqa wrote:
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