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 see...
- 3 years ago
NewStep=Table.TransformColumns(PreviousStepName,{"NDC",each Number.ToText(_,"00000000000")})
donnaorphan
3 years agoNew Member
Took me a few tries, but I got it! Thanks!