Formatting numbers in merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shawndra - 23 Feb 2004 17:03 GMT

I am trying to merge social security numbers into a Word
2002 document from an Excel spreadsheet. I can't get them
to look like social security numbers. Any ideas?

Reply to this Message

Greg Maxey - 23 Feb 2004 17:38 GMT

Shawndra,

You might need to use a numeric picture switch in your
MERGEFIELD e.g.,

{ MERGEFIELD YourMergeFieldName \# ###'-'##'-'#### }

>-----Original Message-----
>I am trying to merge social security numbers into a Word
>2002 document from an Excel spreadsheet. I can't get them
>to look like social security numbers. Any ideas?
>.

Reply to this Message

Graham Mayor - 24 Feb 2004 05:52 GMT

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

Signature

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am trying to merge social security numbers into a Word
> 2002 document from an Excel spreadsheet. I can't get them
> to look like social security numbers. Any ideas?

Reply to this Message