Numbers column forcing 001

Ask for Help
1

Hi, I would like to be able to use a number column but set the column so that the number 1 actually reads 001 etc.

Is this possible?
Thanks

2

Not with the number column, no.

What you could do is use a Pad Text column to insert the extra zeros where necessary.
The only thing is that would return a string, so if you needed to do any calculations with the number, you would need to use the original number column for those.

2 Likes
3

I use this solution :point_up:t3:

1 Like
4

Great, this is perfect.

5

image
image1424×1546 142 KB

Here’s an alternative.

6

thank you