Use Data validation with a type of Whole Number, between 1 and 4444. Format
the cell as 0000.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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