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

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

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

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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