AnsweredAssumed Answered

phone formatting

Question asked by davidcoutts on Aug 5, 2017
Latest reply on Aug 6, 2017 by davidcoutts

following problem :- I have addresses in UK , CH , D and USA - I have made 4 separate tables for these addresses

but would now like to make a new Contact database with all addresses together

I would like to ask if anybody knows a formula for formatting the tel numbers so that all are accepted ?

 

Swiss           061 811 55 55

German       0049 5121 1234

UK               0044 151 400 1234

 

At the moment I have 3 calculations - CH UK D

Outcomes