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
|