You need to sign in to do that
Don't have an account?
r999
How can we count number of digits in a number
I want to count the number of digits in a phone number to restrict the number to 10 digits or some customized number only. I tried this with Len(text), but could not get it. Do we have any other validation already available for this? please let me know if there is any possibility to use count function for this.
Thsnks in advance.
Hi,
You can write the validation rule as below:
LEN(Phone) > 10.
Error message: Phone number can’t be greater than 10.
OR
IF(LEN( text( value(Phone ) ) ) == 10, true, false)
Error message: Phone number can’t be greater than 10.
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
All Answers
Thanks to this forum. I got it from the other posts that we can get it by using
NOT(
LEN(Phone)==10 ). But do we have any ways to avoid NOT for this?
Hi,
You can write the validation rule as below:
LEN(Phone) > 10.
Error message: Phone number can’t be greater than 10.
OR
IF(LEN( text( value(Phone ) ) ) == 10, true, false)
Error message: Phone number can’t be greater than 10.
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.