Data Validation

[Bob]

I need to restrict Data Entry. I need to do two things .
First user can enter Whole Numbers and the user must enter
9 digits. This why the Data Validation feature does not
work for me. It allows one or the other. Either Whole
Number or Text Length. I need both.

Any ideas. Thanks.

 

[Frank Kabel]

Hi Bob
try the following custom formula in data validation (if A1 is the cell
for your entry)
=AND(LEN(A1)=9,MOD(A1,1)=0,ISNUMBER(A1))