Phone Number formatting Issue when trying to copy and paste
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?