Can't use an 8-digit number such as 00000001

"Ron Coderre" wrote:

Try something like this:

Select the cells to have Data Validation, with A1 as the active cell

<Data<Validation<Settings tab
Allow: Custom
Formula: =AND(A10,INT(A1)=A1,LEN(A1)=8)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Connie Martin" wrote:

I want to validate a cell that it must have an 8-digit number put in it---no
shorter, no longer. No matter how I validate the cell it won't work unless I
select "text length". This is not to be text! It's supposed to be an
8-digit number! What gives? How does one validate this cell to restrict it
to just that? How can something so simple be so contrary?