Forum Discussion
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?
Thank you
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.
1 Reply
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.