Forum Discussion

Liam01's avatar
Liam01
Helper I
3 years ago
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 ...
Need Help
  • AnastasiaS's avatar
    AnastasiaS
    3 years ago

    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,

AnastasiaS's avatar
AnastasiaS
Resolver I
3 years ago

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,

  • Liam01's avatar
    Liam01
    Helper I
    3 years ago

    Hi AnastasiaS 

     

    Thanks - that appears to have worked on one dataflow but not on another one! It's odd - the one it's worked on is pulled from a Table whereas the other one isn't. Not sure if that's anything to do with it, i'll keep looking into it.