5 Replies Latest reply on Jul 28, 2015 6:21 AM by SteveMartino

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

    enyko

      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!