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.
Hello Bhavesh,
this did not work out because it is the same like to add a präfix.
1 turns to 001
41 to 0041
I need
1 to 001
41 to 041
But thank you for the idea!
The CONCATENATE function also doesn't help. I tried before and it does not work like in excel.