Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2013-01-06
3
505 Views
Last Modified: 2013-01-06
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
Comment
Question by:morinia
3 Comments
 

Expert Comment

by:dollar4bill
ID: 38749659
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
 

Author Comment

by:morinia
ID: 38749688
I am using WORD 2010 and Excel 2010.  I am bringing the phone number in as a merge field from the Excel spreadsheet.
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 300 total points
ID: 38749702
Use this formula in a new cell/column

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

and hide the previous cell/column.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question