Forum Discussion

raymondwkmok's avatar
raymondwkmok
Frequent Visitor
1 year ago
Solved

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...
Need Help
  • OwenAuger's avatar
    OwenAuger
    1 year ago

    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?

  • shafiz_p's avatar
    shafiz_p
    1 year ago

    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!!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.