Microsoft Excel problem - Date/time cells not recognised / sorted

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


Duration: 3:52
14,523 views
47

I was sorting a big spreadsheet by date. On the surface it would appear that Excel has sorted the spreadsheet, without displaying any error messages. However, on closer inspection it wasn't sorted at all. The weird thing was some dates were recognised and others weren't. Here in this video you will find out why.



Other Videos By Magic Monk


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?
2020-08-10Adobe After Effects - Acceleration Between Key Frames Explained