Data Cleansing m/d/yyyy Dates

A common issue I’ve found with data cleansing when pulling into Excel is the date format wil often default to US format. If it’s a 2 digit month and day (mm/dd/yyyy) then that’s not much of a problem but where it can be one or two digit (m/d/yyyy so 1/1/2020 and 10/10/2020 are both possiblilities) then it can be more tricky. I found this page which describes a way to fix the issue. It seems like a kludge but when I tried it it did work.