AnsweredAssumed Answered

Phone Number formatting Issue when trying to copy and paste

Question asked by TedHouser on Jul 21, 2014
Latest reply on Jul 22, 2014 by philmodjunk

Title

Phone Number formatting Issue when trying to copy and paste

Post

     Hello,
      
     I have a data base that requires 3-4 different phone number fields and i have each field setup with a calculation so that it displays the phone number correctly when they input just the ten numbers....so 3334445555 appears as (333) 444-5555, using this calculation:
      
     "(" & Left(Phone;3) & ") " & Middle(Phone;4;3) & "-" & Right(Phone;4)
      
     My problem is at times they may want to copy one phone number field into another one, but since it is formatted already it copies like this:
      
     (333) 444-5555 copied from one phone field looks like this in the new one
     ((33) 3) -5555
      
     Is there a way to keep all the phone number fields with the formatting in place so that when they type in the ten digits it formats correctly AND if they copy an already formatted number into the phone field it saves it correctly?

Outcomes