Thanks for the help Peter, but it didn't work. I deleted the field code from
the Excel database and using CTRL+F9 typed in what you gave me. When I ran
the merge the numbers still came out 0000000000, with no spaces or dashes.
Can you give me specific instructions or link me to a website that does.

"AngloAlly" wrote:

MS OFFICE v. 2002
I would like to format a merge field in a Word mail merge document like the
telephone number formating in Excel, 3 digits for area code-3 digits
exchange-4 digits number, with the dashes. The data bases I'm using are
either from trade show attendees who swipe badges and the fields are
pre-formatted or if I enter the data the column is formatted in Excel for
telephone numbers so I just enter all 10 digits and it formats itself. Once
I insert the field code into the document, what switches can be applied to
have it print out in the merged document like xxx-xxx-xxxx.