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?