Forum Discussion
Anonymous
4 years agoNot applicable
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...
- 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.
truptis
Community Champion
4 years agoHi 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.