Numbers column forcing 001

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?

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.


I use this solution :point_up:t3:

1 Like

Great, this is perfect.

Here’s an alternative.

thank you