How to use Text.Format for setting a single digit number to doble digit format

[raymondwkmok]

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",{"Leak Sensor", each Text.Format(_, "00")}),

Please may I have your comment and advice for solving this problem.

Thanks
Raymond 

[OwenAuger · Accepted solution]

Hi @raymondwkmok 

Number.ToText is the appropriate function if you want to convert a number to a 2-digit text representation.

I would suggest changing the code for this step to:

#"Set 2 Digit" = Table.TransformColumns(#"Changed Type4",{"Leak Sensor", each Number.ToText(_, "00"), type text})

Does this work for you?

[Anonymous]

Hi @raymondwkmok,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous]

Hi @tongnghi,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[Anonymous]

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.

[shafiz_p · Accepted solution]

Hi @raymondwkmok  You could also try Text.PadStart , Text.From. Try this:

=Table.TransformColumns(#"Changed Type", {{"Leak Sensor", each Text.PadStart(Text.From(_), 2, "0"), type text}})

Hope this helps!!

[OwenAuger · Accepted solution]

Hi @raymondwkmok 

Number.ToText is the appropriate function if you want to convert a number to a 2-digit text representation.

I would suggest changing the code for this step to:

#"Set 2 Digit" = Table.TransformColumns(#"Changed Type4",{"Leak Sensor", each Number.ToText(_, "00"), type text})

Does this work for you?