Data Validation Query

S

SiH23

Hi,

I would be most grateful if someone could offer some advice.

I need to set some kind of validation on columns to only except a 10 digit
number and nothing else. For example if a 9 or 11 digit number is added an
error message is displayed. Is this possible?

Kind regards,

Simon.
 
E

Elkar

Set the ALLOW field to "Custom" then enter this formula:

=AND(ISNUMBER(A1),LEN(A1)=10)

Change A1 to reference the active cell in whatever range you are using.

HTH,
Elkar
 
Top