Forum Discussion
How to change column format?
You will need to add a custom column, and then add the following formula.
=Text.PadStart(Number.ToText([Column1]),4,"0")
The red section converts the numeric column to text. This is required before you can pad out from the left
The blue section then pads out the text string to be (in this case 4 characters long using a "0" as the padding character).
You can use Custom Column in Query Editor,
As shown in the screenshot, Write Custom Column and once it is done delete your original column if not required.
Alternatively, You can use CONCATENATE function as well.
You will need to add a custom column, and then add the following formula.
=Text.PadStart(Number.ToText([Column1]),4,"0")
The red section converts the numeric column to text. This is required before you can pad out from the left
The blue section then pads out the text string to be (in this case 4 characters long using a "0" as the padding character).
perfekt thank you Matt!
also a big thank you for the explanation!
