Forum Discussion
raymondwkmok
1 year agoFrequent Visitor
How to use Text.Format for setting a single digit number to doble digit format
Hi there, I'd like to set the numbers in a cloumn to fixed 2-digit format and used the following formula in Power Query but got an error. #"Set 2 Digit" = Table.TransformColumns(#"Changed Type4...
Anonymous
1 year agoNot applicable
Hi raymondwkmok,
Thank you for reaching out in Microsoft Community Forum.
Thank you shafiz_p , OwenAuger for the helpful response
As suggested OwenAuger, Shafiz_p, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as solution" and give it a 'Kudos' so others can find it easily.
Please continue using Microsoft community forum.
Regards,
Pavan.