### Title

Phone Number formatting Issue when trying to copy and paste

Phone Number formatting Issue when trying to copy and paste

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?

The super talented, Mr Raybaudi's solutions does a few things:

The Let function sets Phone to a variable which is filtered using only the numbers 0-10. So the first thing it does is remove everything that is not a number. Then it puts that filtered variable back into the calculation with the parentheses and the - in the right spot.

The only problem you could potentially have is if someone types in a different amount of numbers then 10.

Let(

Phone = Filter ( Phone ; 1234567890 ) ;

"(" & Left ( Phone ; 3 ) & ") " & Middle ( Phone ; 4 ; 3 ) & "-" & Right ( Phone ; 4 )

)