Forum Discussion

WJ876400's avatar
WJ876400
Helper IV
4 years ago
Solved

Leading zero

Hi   I have a list of ID numbers and some of them are missing a leading zero, the ID number should be 8 digits long the IDs that need a leading zero are only 7 digits long. How do I add a leading z...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    WJ876400 , use only one second is alternate

    example

     

    Text.PadStart(Text.From([Colum]),8,"0")