Solved: Format Phone as 9 digits - Page 2

flxaryaman · 09-01-2023 02:03 AM

How can I format a "phone" column so that it can only contain 9 digits?

Suvrutt_Gurjar

You could start with something like

AND(LEN([_THIS])=9,NUMBER([_THIS])>=100000000)

in the valid_if of the phone column. This assumes the number is only numeric and the first digit cannot be 0. You may need to add other conditions based on how the phone numbers are in your country,

View solution in original post

Suvrutt_Gurjar

@flxaryaman wrote:

The phone number format in Spain is:
123456789
34123456789
Could a formula be made that includes these two formats?

Please try in the valid_if

OR(

AND(LEN([_THIS])=9,NUMBER([_THIS])>=100000000) ,

AND(LEN([_THIS])=11,NUMBER([_THIS])>=34100000000)

)

Edit: Made one minor change in the condition. Changed it from 34000000000 to 34100000000

View solution in original post