Forum Discussion

donnaorphan's avatar
donnaorphan
New Member
3 years ago
Solved

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...
  • wdx223_Daniel's avatar
    3 years ago

    NewStep=Table.TransformColumns(PreviousStepName,{"NDC",each Number.ToText(_,"00000000000")})