Random Auto Number

[emdiesse]

How can I make random auto numbers 8 digits in length (including leading zeros) and always positive?

Thank you

 

[antomack]

Look up randomize and Rnd in your help file, the following formula should give you what you need, a number between 1 and 99,999,999 with leading zeros.

format(((99999999 * Rnd) + 1),"00000000")

 

[emdiesse]

Look up randomize and Rnd in your help file, the following formula should give you what you need, a number between 1 and 99,999,999 with leading zeros.

format(((99999999 * Rnd) + 1),"00000000")

But I would like it to come up with unique numbers that have not already been chosen.