Microsoft Excel Tutorial - How to convert date/time format in CSV from US to International

In my previous video you saw the problem where date/time cells can't be sorted because Excel isn't recognising the US format in the dates and my Windows is located in Australia. Here is a video on how to transform the date data in a CSV file into the Australian / International format.

[werken-aan-projectennl]

I was looking for hours. You helped me solve this.

In my case:
1. I had to split the date field in 2 columns (on the second tab: transform): choose "split on number of characters", one time from the left
2. Now the date and the time are seperated in two different columns
3. then follow the procedure of the video.

Thank you very much!

[ivanwong]

My project was stuck for a long time due to date format issue. Thank you. This is a lifesaver.

[natashaboselloyd]

i was trying to figure this out for so long - can believe the solution was soo simple- thanks a lot :)

[meerasolanki]

You’re the legend. Finally fixed the issue after spending hours.. thanks heaps!!

[media_bear]

Wow Amazing, Thank you for the most useful 4:20 of my life👏👏👏

[pablofts]

Well, you actually did de second part haha

Thanks, mate

[ronykj]

Man. you made my day. Thank you soo much.

[vijaykrishnadaregama]

hey man in which way you want me to thank this is absolutely helpful thankyou so much dear keep doing more videos