Forum Discussion
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 all 7k records by date (year, month, day). Time is not needed / can be deleted.
Any ideas would be welcome!
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!
