Power Query is parsing the dates incorrectly? How to fix?

[jplank]

I have a table that I've loaded into Power Query Editor. One column is a date that is being read in incorrectly. For example, the date will show 04-Jan-16 and it's being read as Jan 16, 2004. But it should be read as Jan 4, 2016. Is there a way to tell Power Query how to use dd-mmm-yy format when reading the date?

 

[sandy666]

screenshot please?

source too

 

[jplank]

Here is the data as read from the excel file:

Here is the data after labeling the column type as Date:

I'm not sure how to attach the source workbook to this post.

 

[sandy666]

so try this to change

choose country with dd/mm/yyyy
but it all depends on your regional settings (windows)

or in Query Options

 

[sandy666]

will be better if you convert date column in source data via Text To Columns and choose there proper format
because here (on the picture) your date is as text not as date, less troubles

 

[jplank]

I agree, but unfortunately, the source spreadsheet is not something I'm able to edit.

 

[sandy666]

so you're probably limited to options from post#4
or set it manually (eg. split, add prefix, change month text to number, merge in correct order ...)