Skip to main content

I need several zeros before my number in a number field. Any way to accomplish this without writing code? I numbered and filled, then changed it over to text field, but now I have to add the zeros to all the numbered cells.


So two questions:

Can I append zeros to the text field cells numbers automatically or

Can I get a numbering field to recognize zeros before the integer?


Thanks!

Hi @Bethany_Hacker and welcome to the community!



You could use a formula field field, based on the number you entered, to add the zeros, but it can’t be formatted as a number field.

eg: "00000" & Number



Not in a number field as far as I know.

Welcome to the Airtable community!


If you have a number field with an integer, and you want to pad it with leading zeros to get a text string that always has the same number of digits, you can use a formula field.


IF(

    {number},

    CONCATENATE(

        REPT(

            "0", 

            12 - LEN({number} & "")

        ),

        {number}

    )

)

If you have a text string that is an integer with leading zeros, you can convert it back to a number with a formula field.


VALUE({Number with Leading Zeros})

or


IF(

    {Number with Leading Zeros},

    VALUE({Number with Leading Zeros})

)

Reply


Terms & Conditions