format telephone numbers Mail Merge

[KimB]

I'm creating labels using an Excel file for my database. I need to include a
telephone number on my label. Since the formating in Excel does not cross
over into Word, how do I get my label to show a telephone number as
(xxx)xxx-xxxx or even xxx-xxx-xxxx instead of xxxxxxxxxx?

 

[Guest]

In Excel go to:

Format
Cells
Number
Special
Phone Number (US)

Larry T.

 

[Guest]

Hit send too soon,

If the formating doesn't come over, then I would use multi cells with word
providing the separators and spaces.

LT

 

[Graham Mayor]

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and
http://www.gmayor.com/formatting_word_fields.htm

The switch you require here is \# "(000)000'-'0000"

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>