Cell Date Conversion

[Ted White]

Hello - I am trying to convert a current date format from a column (of 7k records) from

9/26/17, 10:42 AM

 to 

2017/9/26

Or something similar so that I can sort all 7k records by date (year, month, day). Time is not needed / can be deleted.

Any ideas would be welcome!

[#2 · Accepted solution]

Hi Ted,

You may use Data->Text to columns using comma as separator and selecting for first column Data->MDY on third stage of the wizard. Second column with time could be deleted after that.

[#3]

Sergei is - "the man"! Wow, thank you my friend!