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 : LinkedIn: nitinparanjape
Twitter : 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)

• #science_technology
• #csv_import
• #date_format_repair
• #date_import_problem
• #date_format_mismatch
• #text_import_wizard
• #excel_csv_import
• #excel_csv_import_problem
• #power_query
• #date_using_locale
• #operational_risk
• #excellent_operational_risk
• #power_query_excel
• #risk_management
• #power_bi