Autogenerate 4 digit numbers

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


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


1 Like