Data Validation

G

Guest

Please help - I need data validation that allows 9 digits for SS#'s. I can
set the validation to allow 9 digits in the text length of an entry (works
fine -most of the time), but excel won't allow an entry that BEGINS with zero
when I do this. Is there a way to customize the validation to allow 9 digit
figures "including zero"?
 
J

JE McGimpsey

One way:

Allow: Whole Number
Data: Between
Minimum: 10000000
Maximum: 999999999

Alternatively, format the cell as Text, and use

Allow: Custom
Formula: =AND(ISNUMBER(--A1),LEN(A1)=9)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation? 2
Format Cell and Data Validation 4
Setting Data Validation 2
Data Validation 2
Data Validation using Unique Values 2
Zip Code Validation - length =5 or 9 11
Data validation 3
2007 data validation not working 1

Top