Merging phone and Social Security numbers from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 11 Sep 2004 23:05 GMT

I am trying to insert the information from an excel sheet into a word
document but the the formating is not there. It is formatted in Ecell for
example (xxx) xxx-xxxx comes into word xxxxxxxxxx. Social security numbers
likewise do not have the "-"
Thanks

Reply to this Message

Doug Robbins - 11 Sep 2004 23:47 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am trying to insert the information from an excel sheet into a word
> document but the the formating is not there. It is formatted in Ecell for
> example (xxx) xxx-xxxx comes into word xxxxxxxxxx. Social security
> numbers
> likewise do not have the "-"
> Thanks

Reply to this Message

Gladys - 07 Aug 2006 17:06 GMT

Laymans Terms

Merge as normal
In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with phone number formats.
For example:
{ MERGEFIELD "Phone" \# "(###)'-'####" }
4. Press Alt+F9 to hide the field codes.
5. Update all labels
5. Save the Main Document

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 7 lines]
> > likewise do not have the "-"
> > Thanks

Reply to this Message