Forum Discussion
Solved
Cell Date Conversion
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 al...
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.
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.
Sergei is - "the man"! Wow, thank you my friend!
