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

Channel:
Australia Magic Monk
Subscribers:
64,000
Published on ● Video Link: https://www.youtube.com/watch?v=aIKCPE2d1KY


Category:
Tutorial
Duration: 4:21
8,214 views
82

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.



Other Videos By Magic Monk


2020-10-03Can Mail Merge do multiple records on one page in MS Word
2020-09-30Is Freesync turned off for your monitor? (Xiaomi Mi Curved 34")
2020-09-27144Hz refresh rate monitor running at 50Hz?? How to fix! (Xiaomi Mi Curved 34")
2020-09-26Travel around Europe with Xiaomi Redmi 6 and DJI Osmo Mobile 2 - Český Krumlov Episode 15
2020-09-25Travel around Europe with Xiaomi Redmi 6 and DJI Osmo Mobile 2 - Český Krumlov Episode 14
2020-09-24Unboxing / Review: Xiaomi Mi Curved 34" 144Hz WQHD 21:9 FreeSync Gaming Monitor
2020-09-24Travel around Europe with Xiaomi Redmi 6 and DJI Osmo Mobile 2 - Český Krumlov Episode 13
2020-09-21Unboxing / Review: Samsung 31.5 inch Curved 1920x1080 Monitor LC32F391FWEXXY
2020-09-18Microsoft Excel - How to extract just the Date from Date/Time cell
2020-09-15Bouldering Green Route @ Brisbane Rock Climbing Gym Urban Climb Milton
2020-09-12Microsoft Excel Tutorial - How to convert date/time format in CSV from US to International
2020-09-09Microsoft Excel problem - Date/time cells not recognised / sorted
2020-09-06Microsoft Word - AutoText Quick Parts Settings Won't Save Fix
2020-09-03Intermediate Orange Route #2 Top Rope Rock Climbing filmed with Samsung Galaxy S10e
2020-08-31How to create a screen capture video using Microsoft Teams
2020-08-28Easy Vegan Muffin Baking Tutorial
2020-08-25Intermediate Green Route #6 Top Rope Rock Climbing filmed with Samsung Galaxy S10e
2020-08-22Intermediate Orange Route #1 Top Rope Rock Climbing filmed with Samsung Galaxy S10e
2020-08-19Microsoft Excel VBA Tutorial - How to create folders part 2
2020-08-16Microsoft Excel VBA Tutorial - How to create folders part 1
2020-08-13How do my macros disappear in my Microsoft Excel spreadsheet?