Data Validation Rules

[pan_kaj]

Hi there,

Is there a way to restrict cell input to 8,12,13,14 digits only, please? No text, only numbers.

Hope to get some helpful suggestions.

Thanks,
Ashima

 

[JustynaMK]

Hi Ashima,

If you want to enter your value into cell A1, then have it selected and then go to Data > Data Validation > Custom - Formula:
=OR(A1=8,A1=12,A1=13,A1=14)

Is this what you were looking for?

 

[pan_kaj]

No, 8,12,13, 14 are the number of digits that I want to restrict the cell inputs by.

 

[RoryA]

You could use a custom validation formula like:

=AND(ISNUMBER(A1),OR(LEN(A1)=8,LEN(A1)=12,LEN(A1)=13,LEN(A1)=14))

where A1 is the cell you are validating. Be sure to uncheck the Ignore blank option.