Hi,

I have tried both of these and it still allows me to insert less/more than 6 digits and allows duplicates?

Does it make a difference that my numbers are stored as text? - sorry for not mentioning if it does (i have them stored as text due to the number 0 at the beginning, without it stored as text it removes the 0's)

Regards,