Microsoft Query error

Hello all,

I made a Microsoft Query in Excel to import some data from another workbook and now something strange happend.
In the attached file you can see the imported part on the left side and the original part on the right side.
As you can see, the second row on the imported part (left side) is 06.11.2017, but it should be 11.06.2017.
The rest are fine...

Any ideea please?

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
Please attach a sample file(s) that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

To attach an Excel file(s) to your post,

• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post