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" wrote in message
...
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.
--
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.
--
Cathy

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

--

Graham Mayor - Word MVP

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




Cathy wrote:
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.