3 件の回答
hi Luca,
You can try
OR(MID(Phone, 2, 2) = "00",
NOT(REGEX(Phone, "\\([0-9]{3}\\) [0-9]{3}-[0-9]{4}"))
)
It should throw error if phone number is not in US number format or if first 2 digit is 00
or if there is some other number format, and you just want to check starting 2 digit, you can use
OR(
extsting validation for phone number ,
Left(Phone , 2) = "00"
)
Thanks
