This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have issue with dates format in excel - i receive export with 2 format dates in 1 column (from tableau system)
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
The link did not work / is not a public link / access denied.
Create a public link or upload your file into my dropbox:
Microsoft Answers Community Public Request - Dropbox
Andreas.
hi, we followed the mentioned steps and it is still not working - the data has not been changed, and moreover, I'm not able to set up the date filter, as the format of the data is not correct
"17/06/2024" means 17 Jun 2024, that's usually the format dd/mm/yyyy used in UK, so change the locale in PQ to English(UK) and the issue is gone.
If you need further help I need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
Andreas.
Hi, I followed the steps together with local IT support and unfortunately we still couldn't solve the issue - it shows error after we followed instruction with Power Query . Could you provide more specific steps on how to operate the data to fix the issue with the format dates?
Import the file/data using Power Query, same way as described here:
Power Query - How to import a CSV file that does not match your locale - Microsoft Community
Andreas.