Only number is allow not other sign like +, %,- and etc

[desmond_lee]

Hi Guy

I have a question here. Is it possible expression under the valid_if for key data ONLY NUMBER under the data type Phone ? Very there is user keep key in +15 or +23 and etc

[Suvrutt_Gurjar · Accepted solution]

Please try in the valid_if setting of the phone column

SUBSTITUTE(NUMBER([_THIS]),",","")=[_THIS]

[Suvrutt_Gurjar · Accepted solution]

Please try in the valid_if setting of the phone column

SUBSTITUTE(NUMBER([_THIS]),",","")=[_THIS]

[desmond_lee]

Wow really expert. What about I would like to add another condition. The addition condition is the leading number must be >=1. Mean 015 is not acceptable. Should be 15

[Suvrutt_Gurjar · Accepted solution]

Please try 

AND(SUBSTITUTE(NUMBER([_THIS]),",","")=[_THIS],
NUMBER(LEFT([_THIS],1))>=1
)

[desmond_lee]

Wow thanks a lot. Work perfectly