Data Validation Query

[Guest]

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.

 

[Guest]

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