Easily Fix Dates Formatted as Text with Power Query

Power Query makes fixing dates entered as text in Excel super easy, and it's quick to update when you get new data.

[cuboseta]

Mynda I'm brazilian and want to enormously THANK YOU for the lessons. Literally saved my job! God bless your job.

[libbyreiser]

Brilliant lesson, Mynda, as always. Clear. Crisp. No waffling around (love your phrase). I am often faced with global database dates in... text format. Your lesson is cool, clever, and instantly actionable for me. I always learn more than I ever expect. Well done.

[georgel]

I cannot believe the timeliness of this video! I had this exact problem this week. Great help. Thank you for the video instruction. So simple!

[vijayarjunwadkar]

Wow, Mynda, once again you read my mind and I got this video just in time, when I was struggling with dates in CSV! Thank you so much! 😊👍

[felipe]

Thanks Mynda! dates are one of the most important data in data bases, these conversions are really usefull!!

[IvanCortinas_ES]

I follow all your videos with great expectation, especially those about Power Query. Thank you very much for your dedication.

[newmasuzzo]

Mynda, thank you so much for saving me from trying everything that did not work.
Brilliant video as usual.

[nurmohammedmunshi]

A talented expert I have ever seen before. A lots of respect from my heart ♥. God bless you.

[ziggle]

Beautiful exposition! Also wanted to mention that I took your dashboard course and I use the techniques I learned there every day.

[donlanky]

Where has this been all week? I have been stuck trying to solve the issue with mixed date. You definately have a new sub. Thanks much

[cholaterahul]

Cool steps, thanks mam. i dabbled with lot of options in Power Query before hitting your video. Loved your explanation and solved my problem.

[JanBolhuis]

Brilliant video. Thank you so much. A great time saver.

[LindseyBuckle]

Wow. Learnt two new things today: splitting by position and column from examples. How did I not know it was that easy? Thank you!!

[rajeevgosavi]

Great Madam, This tutorial is simply superb, You have explained in a very simple way to understand. Thanks again. Looking forward to many more on PQE.

[willytrazza]

WOW !

I'm using Excel for years but this lesson was an eyeopener.
Thanks for this video (and all others on your channel)
Well done - you made my day 😀

[wayneedmondson]

Hi Mynda. Awesome examples! Thanks for showing the various ways to use Power Query to fix dates formatted as text. Thumbs up!!

[garethwoodall]

Many thanks I had to use the locale method for the first time today really appreciate your channel Mynda!

[RCTurbine]

Thanks Mynda, I work with US dates all the time, and this really helps.

[TheOrganizedProfessional]

You are a life saver. Thank you so very much!

[MrMkx]

Amazing - Example 5 was my issue, super easy fix!! Thank you so much!!