Validation

B

Bonbon

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
 
B

Beege

Bonbon

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

Beege
 
B

Bob Phillips

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)
 
Top