When doing a mail merge through excel, the phone numbers don't show up
in the correct format. ex. (518)555-1212 comes out as 5185551212.
How can this be corrected?
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
FxM
When doing a mail merge through excel, the phone numbers don't show up in the correct format. ex. (518)555-1212 comes out as 5185551212. How can this be corrected?
Thanks!
Joe
Hello Joe,
After you detect that .fr groups are french speaking one, you can try :
for numbers : "("000")"000"-"0000 as format (not sure that it doesn't already exist in phone numbers formats)
for text : ="(" & mid(A1,1,3) & ")" & mid(A1,4,3) & "-" & mid(A1,7,4) In our French Excel, mid is written STXT. Mid is VBA command, hope the same in formulas.
HTH
@+ FxM
When doing a mail merge through excel, the phone numbers don't show up
in the correct format. ex. (518)555-1212 comes out as 5185551212.
How can this be corrected?
Thanks!
Joe
Hello Joe,
After you detect that .fr groups are french speaking one, you can try :
for numbers : "("000")"000"-"0000 as format
(not sure that it doesn't already exist in phone numbers formats)
for text : ="(" & mid(A1,1,3) & ")" & mid(A1,4,3) & "-" & mid(A1,7,4)
In our French Excel, mid is written STXT.
Mid is VBA command, hope the same in formulas.
When doing a mail merge through excel, the phone numbers don't show up in the correct format. ex. (518)555-1212 comes out as 5185551212. How can this be corrected?
Thanks!
Joe
Hello Joe,
After you detect that .fr groups are french speaking one, you can try :
for numbers : "("000")"000"-"0000 as format (not sure that it doesn't already exist in phone numbers formats)
for text : ="(" & mid(A1,1,3) & ")" & mid(A1,4,3) & "-" & mid(A1,7,4) In our French Excel, mid is written STXT. Mid is VBA command, hope the same in formulas.
