-2

Note : We can't change the field type to number because it is existing field.

Improve this question
3
  • NOT(ISNUMBER(Envent_A__c ) && ( LEN(Envent_A__c ) >= 4 && LEN(Envent_A__c ) <= 8))
    – SAK
    Commented Mar 29, 2019 at 12:33
  • 2
    You should add this information to your question by making an edit. Comments are best thought of as temporary, and their limited length and formatting options generally make it harder for others to incorporate into answers or replies.
    – Derek F
    Commented Mar 29, 2019 at 12:51
  • If your required length is 12-13 characters, why is your validation rules to reject only 4-8 character length strings?
    – David Cheng
    Commented Mar 30, 2019 at 22:48

2 Answers 2

Reset to default
2

you can try following:

    or(
      NOT(ISNUMBER(Text__c )),

      AND(
         LEN(Text__c ) != 12,
         LEN(Text__c ) != 13
     )
   )

Cheers Rainer

Improve this answer
0

Text field that you created, provide 13 value (so that it can take maximum of 13 characters in it) as Length and mentioning about that it should contain only the numeric value, we can write the validation as:

NOT(ISNUMBER(TextField))

Let me know this helps!

Improve this answer

Not the answer you're looking for? Browse other questions tagged .