Changing xl cell format for Word mailmerge

[Big Lar]

I have a db of nearly 500 names/addresses/phone numbers in xls.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Phone columns are formatted Special/phone number...so 3333333333 is displayed as (333) 333-3333
<o> </o>
I am creating several Word docs using MailMerge with the xls as the data source.
The docs display the phone numbers without the xl cell format.
<o> </o>
Rather than change each xl entry, I’m looking for a method to change the cell values to include the ( ) and -

Possible? I hope.

 

[Big Lar]

Darn...guess not.

 

[John_w]

In your Word mail merge main document, type Alt+F9 to display the merge field codes.

Your phone number merge field probably looks something like this:

{ MERGEFIELD "Phone" }

Put the cursor immediately before the } and change it to:

{ MERGEFIELD "Phone" \# "(####) ###'-'####" }

See 'Telephone Numbers' section in http://www.gmayor.com/formatting_word_fields.htm for more details.

Type Alt+F9 again to hide the field codes.

 

[Big Lar]

Outstanding! Thanks, John.