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,
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,