loss of phone number formatting when merged

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cathy - 31 Mar 2005 19:19 GMT

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.

Signature

Cathy

Reply to this Message

macropod - 30 Mar 2005 22:21 GMT

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

> 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.

Reply to this Message

Graham Mayor - 01 Apr 2005 08:35 GMT

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

Signature

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

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

> 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.

Reply to this Message