Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
loss of phone number formatting when merged
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phone number field formating | Microsoft Word Help | |||
How do I maintain number formatting in a mail merge? | Mailmerge | |||
Formatting Issue on Number Field | Mailmerge | |||
how to format phone number merged fields? | Mailmerge | |||
How do I format a phone number in a mail merge? | Mailmerge |