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")

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi WJ876400 ,

Has your problem been solved by amitchandak 's solution? If yes, please consider accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj