• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 594
  • Last Modified:

Formatted telephone number losing format from Excel to Word in mail merge

I have an excel file which I have formatted the phone numbers to:
(800) 111-1111.  When I merge the file into WORD, the formatting is lost.
I get 8001111111.  What can I do to keep the formatting.

I am using special - phone formattig in Excel
0
morinia
Asked:
morinia
1 Solution
 
dollar4billCommented:
What versions of Excel and Word are you using? I believe in 2007 or newer you can paste special and that should keep the formatting.
0
 
moriniaAdvanced Analytics AnalystAuthor Commented:
I am using WORD 2010 and Excel 2010.  I am bringing the phone number in as a merge field from the Excel spreadsheet.
0
 
Saqib Husain, SyedEngineerCommented:
Use this formula in a new cell/column

=TEXT(A1,"[<=9999999]###-####;(###) ###-####")

and hide the previous cell/column.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now