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.

Published by stephenboothuk

A former Oracle DBA, then Technical Business Analyst and now I'm not sure what I am. If you want to find out more about me, my LinkedIn profile can be found at:

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: