loss of phone number formatting when merged

[macropod]

Hi Cathy,

The phone number in Excel is still a plain number - it's just formatted for
screen print purposes. To get the same result in Word you need to add a
numeric picture switch to the merge field. For example:
{MERGEFIELD Phone \# "(00) 0000 0000"}

Cheers

 

[Cathy]

When merging phone numbers from an excel spread sheet into a word document
the phone number becomes one long number rather then the formatted number it
had been in excel. The numbers are formatted in excel by highlighting the
column, chosing format/cell/special/phone number. Thanks for your help.

 

[Graham Mayor]

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

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


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