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? Feb 28, 2019 at 4:47
  • Single line of text.
    – Tara
    Feb 28, 2019 at 4:48

1 Answer 1


Try using below formula:



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, 2019 at 4:55
  • Welcome, Please upvote and accept if it helped you. Feb 28, 2019 at 5:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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