Format from Excel not being shown in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Helen - 09 Nov 2005 18:46 GMT

Hi,

I have created a mail merge in Word from an Excel spreadsheet. The
spreadsheet contains social security numbers that are stored as numbers
999999999 but formatted as 999-99-9999. When doing the mail merge Word will
display the SSN as 999999999, not as 999-99-9999. How can I fix this?

Thanks!!

Helen

Reply to this Message

Doug Robbins - Word MVP - 09 Nov 2005 19:06 GMT

Add the following formatting switch inside the closing } of the mergefield.
Use Alt+F9 to toggle the display of the field codes.

\# "###'-'##'-'####"

For example

{ MERGEFIELD SSN \# "###'-'##'-'####" }

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 7 lines]
>
> Helen

Reply to this Message

Helen - 09 Nov 2005 19:14 GMT

Works great!

Thanks!!

Helen

> Add the following formatting switch inside the closing } of the mergefield.
> Use Alt+F9 to toggle the display of the field codes.
[quoted text clipped - 24 lines]
> >
> > Helen

Reply to this Message