Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I have a string column with a number of chars in it that can be up to 10, I need to fill the beginning of each cell with "0"s so that each cell is 10 chars. So, for instance, transform this
12345
3948
36
1234567890
48975646
Into :
0000012345
0000003948
0000000036
1234567890
0048975646
Hi,
Use a formula. If your column is called stuff and you want 11 chars in the output, use:
format("%011d", stuff)
Hi,
Use a formula. If your column is called stuff and you want 11 chars in the output, use:
format("%011d", stuff)