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 seem to do it!

 

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

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion

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