0

I need to use a column to capture ID numbers. I need a way to ensure that the answers entered are only numbers and exactly 12 digits in length. I've tried a zillion different formulas but keep getting syntax errors. Can anybody help me?

  • What is the type of field? – Ganesh Sanap Feb 28 at 4:47
  • Single line of text. – Tara Feb 28 at 4:48
0

Try using below formula:

=IF(LEN([FieldName])=12,ISNUMBER([FieldName]+0),FALSE)

Note:

Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,).

  • Awesome! Yeah, the semicolon didn't work but the comma did. Thanks so much for your help! – Tara Feb 28 at 4:55
  • Welcome, Please upvote and accept if it helped you. – Ganesh Sanap Feb 28 at 5:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.