Validation

[Guest]

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

 

[Beege]

Bonbon

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

Beege

 

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

 

[David McRitchie]

You have almost answered your own question "validation"
see entries in topics index for data validation
you want to include a check on the length if text,
or on the range if a number
http://www.contextures.com/tiptech.html
and it would probably also be shown in one of the videos at
http://www.datapigtechnologies.com/ExcelMain.htm