How to have numbers that begin with Zero?

Chris_Scott1 · May 3, 2022, 2:41pm

Hi, I’m looking for a way to start a group of sequential numbers with 0, for example 01, 02,03 etc. But for some reason I’m unable to figure it out by changing the column type. Is there a way to accomplish this?

Thank You!

natalie-grist · May 3, 2022, 2:47pm

Hi Chris!

Welcome to the Community. The table linked below has examples of two different methods you can use to add leading zeros. In the example, I use row ID as the value to format.

https://public.getgrist.com/p4zvsX9asVCc/2179-Using-id/p/1

The first method can be seen in the 5-Digit ID column. To simplify this, if you wanted to add a single leading zero (to have a two digit value), the formula would be:

'{:0>2}'.format($id)

The other method is the zfill Method. Again, to have a two digit number, the formula would be:

str($id).zfill(2)

Let me know if you have any questions!

Chris_Scott1 · May 3, 2022, 3:06pm

natalie-grist:

The table linked below has examples of two different methods you can use to add leading zeros. In the example, I use row ID as the value to format.

#2179 - Using $id - Grist

The first method can be seen in the 5-Digit ID column. To simplify this, if you wanted to add a single leading zero (to have a two digit value), the formula would be:
'{:0>2}'.format($id)
The other method is the zfill Method. Again, to have a two digit number, the formula would be:
str($id).zfill(2)

Excellent!! Thank you Natalie!!