Data Validation

  • Thread starter Thread starter Bob
  • Start date Start date
B

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