Solve date format problems with CSV import in Excel

#msexcel #datacleaning #efficiency365 Importing dates from CSVs can be tricky. If the input date format and the PC date format does not match, days and months get swapped. Half the dates will remain text. Here you can see two solutions for this problem: one using Excel native feature - Text import wizard and second - a modern solution - using Power Query. Contents --------------- 00:00 Introduction 00:26 Problem 02:47 Root cause 03:12 Solution1 05:13 Best solution - Power Query The first solution will work with any version of Excel. Second solution requires Power Query which is available with newer versions, including Office 365 version. Buy Dr Nitin's latest book ----------------------------------------- Efficiency Best Practices for Microsoft 365 130 best practices everyone must know Work Smarter, Grow Faster https://s.efficiency365.com/bk Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario. Dr Nitin's Office Masterclass ---------------------------------------------- https://hi.switchy.io/mms Udemy Courses by Dr Nitin Paranjape -------------------------------------------------------------- Pivot Table Advanced - https://hi.switchy.io/22B1 Excel to Power BI - https://swiy.io/pivotsh Learn more from 1000+ blog articles by Dr Nitin Paranjape Efficiency 365 blog: https://efficiency365.com/blog LinkedIn :   / nitinparanjape   Twitter :   / drnitinp   Production -------------------- Music and Effects: https://elements.envato.com/ Created using Adobe Premiere: https://www.adobe.com/in/creativeclou... AI based captions: https://videoindexer.ai (Microsoft service)