unable to covert date

[lastnn30]

Hi

The table below I Get it from Web --> https://www.theweathernetwork.com/ca/14-day-weather-trend/ontario/toronto

I cleaned the table and kept Day, Date, High Temperture, Low Temperture columns. Power Query is showing the date column is Text (ABC), when I tried to change to Date, I got error messages. Some date like 

05/26

05/27

wont covert to date but date like

06/01

06/02

will covert to date no problem.

Now I am thinking that is because of my computer date format is dd/mm/yyyy.

How can I fix that without change my computer date format. Thank you very much.

The file can be found here:

https://drive.google.com/file/d/16xl7PA9X0RqH5TsGm2xQZ8RDqUw8eTsz/view?usp=sharing

[Nathaniel_C · Accepted solution]

Hi @lastnn30 ,
In Power Query, right click on the top of the column, select change type, and select using locale.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[lastnn30]

Got it. Thank you so much for the help. I appreciate it.

[Nathaniel_C]

Hi @lastnn30 ,
You are very welcome!

Nathaniel