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")})
wdx223_Daniel
3 years agoCommunity Champion
NewStep=Table.TransformColumns(PreviousStepName,{"NDC",each Number.ToText(_,"00000000000")})