Data Validation Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top