Autogenerate 4 digit numbers

Hi,
I am creating a client job tracker and would like to autogenerate 4 digit numbers, eg. 0001, 0002.
Can someome please help as I can only get a single digit or decimals so far.

Thanks Daz

Hi @Darren_Ledwich - you need an autonumber field (which you can then hide), then create a formula field using this:

REPT('0', (4 - LEN({ID} & ''))) & ID

JB

Jonathan that is brilliant.
Thanks so much for the quick response too.

Daz

1 Like