Bonbon

Try Data/Validation Custom =AND(A10,A1<4444)
And format cells Custom 0000

Beege


"Bonbon" wrote in message
...
Hi again, following up my last post with product codes such as 0001, 0002.
Does anyone know what i should eneter for the formula to validate these
cells
so only a 4 digit code could be entered and lets say the limit is 4444.
what
is the formula?

Thx in advance
Bonbon