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?

In Excel go to:

Format
Cells
Number
Special
Phone Number (US)

Larry T.

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

See http://www.gmayor.com/mail_merge_lab...th_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

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


KimB wrote:
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?