Forum Discussion
Solved
Date Format
Hello, I'm having problems with trying to keep the date format of my original Excel sheet that forms the basis of a report. In Excel it's in the correct UK format - DD/MM/YYYY - but when i'm ...
Hello Liam01
When in Power Query, have you tried to:
First - change data type to text (normally you'll have only ABC instead of ABC123).
Then - change the format using locale (right clic -> Change type -> Using locale).
Sometimes the intermediate step, transform to text, resolves this problem.
Regards,
To add to this, I'm looking at the Date Modified for pulling through the most recent file and that date in Sharepoint is in UK format but in Power Query, it shows as US format. Tried the suggested fix and that doesn't resolve it here.