Forum Discussion
donnaorphan
3 years agoNew Member
Adding leading zeros
I need to add leading zeros to numbers in an alphanumeric column to make each one 11 characters. How can I do this? I've been trying to do it by following some other help questions, but just can seem to do it!
NewStep=Table.TransformColumns(PreviousStepName,{"NDC",each Number.ToText(_,"00000000000")})
2 Replies
- wdx223_DanielCommunity Champion
NewStep=Table.TransformColumns(PreviousStepName,{"NDC",each Number.ToText(_,"00000000000")})
- donnaorphanNew Member
Took me a few tries, but I got it! Thanks!