AnsweredAssumed Answered

Adjust my phone number formula to allow a correctly formatted entry.

Question asked by enyko on Jul 20, 2015
Latest reply on Jul 28, 2015 by SteveMartino

Title

Adjust my phone number formula to allow a correctly formatted entry.

Post

Hi, so there are of course many posts about formatting a phone number field. I have mine working nicely where when 1234567890 is entered, it formats it to (123) 456-7890. BUT...when I enter in it correctly (rather paste it in there), it doesn't like the format and makes the field blank. So after pasting "(123) 456-7890" I have to remove the formatting to make it; "1234567890" each time. How do I adjust my formula to allow a correctly formatted entry?

If(Length(C1 Phone 1)=10; "(" & Left(C1 Phone 1;3) & ") " & Middle(C1 Phone 1; 4; 3) & "-" & Right(C1 Phone 1;4))

 

Thanks!

Outcomes