Problem with formating

[Stax82]

Hi,
In my excel-sheet (source document) I have a column with ssnr in the format "########-####" and some with "########-T###". The format in the column in excel is Custom "########-####".

How can I merge this numbers in to my word document?
Right now I have "{MERGEFIELD ssnr \# ########'-'####}"
When I merge and the source document contains a T the result in my word document is just "-".

[macropod]

You should get the desired result just by omitting the field switch; otherwise, see Mailmerge US Social Security Number Formatting in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html

[Stax82]

Originally Posted by macropod

You should get the desired result just by omitting the field switch; otherwise, see Mailmerge US Social Security Number Formatting in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html

If I omit the field switch \# ########'-'#### then i got the a decimal number 1,#########e+11 for the SSN's without a T in them.

[macropod]

Try making sure the first record or two have the T in them, or create a dummy first record with just some text in that field.