How do I format telephone numbers in Word?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ghllag - 05 May 2005 14:21 GMT

I have an MS Word document that I'm trying to mailmerge. The datasource is an
Excel spreadsheet and contains telephone numbers. The telephone number
field is a number field with telephone display format (I did this to
facilitate easy data entry). When I mailmerge my Word document (the fields
get inserted into a table), the telephone numbers appear without formatting.
How can I tell Word to format the number as telephone? I'm using Word
2002-SP2.

Reply to this Message

Greg Maxey - 05 May 2005 14:32 GMT

First see the sectionon Excel data at:

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

or you could use a format swith:

\# "(###) ###'-'####"

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> I have an MS Word document that I'm trying to mailmerge. The
> datasource is an Excel spreadsheet and contains telephone numbers.
[quoted text clipped - 3 lines]
> telephone numbers appear without formatting. How can I tell Word to
> format the number as telephone? I'm using Word 2002-SP2.

Reply to this Message

Graham Mayor - 05 May 2005 15:28 GMT

Or see my other web page http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> First see the section on Excel data at:
>
[quoted text clipped - 11 lines]
>> telephone numbers appear without formatting. How can I tell Word to
>> format the number as telephone? I'm using Word 2002-SP2.

Reply to this Message