Data Validation
 

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"?

Data Validation
 

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)




In article ,
Teddy-B wrote:

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"?

Data Validation
 

Works Perfectly!
Thanks for your time and help :-)

"JE McGimpsey" wrote:

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)




In article ,
Teddy-B wrote:

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"?