Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Change Month format

Hello everyone,    I have this format for Month January  1 February 2 ... December 12     I want  January  01 February 02 ... December 12   Any idea which format I can use?   T...
  • truptis's avatar
    4 years ago

    Hi Anonymous ,

    You can do it in Power Query. Click on Transfor Data -> Add Column-> Custom Column & put the below code:
    =Number.ToText([Month],"D2")

    Anonymous -> if this helps you then please hit the thumbs up & mark it as a solution. Thank you.