Custom format a merge field

[paul h]

I am exporting a merge file from Access that has Soc Sec Num as a merge field. Can I simply export the unnformatted number and then format it in the merge field as using a Social Sercurity format i.e. 111-22-3333 like I would use in Access or Excel?

[macropod]

What Access and Excel have is a display format for SSNs. You can achieve the same in a mergefield via a switch. Right-click on your mergefield and press Shift-F9. You should see something like:
{MERGEFIELD SSN}
Add a numeric picture switch, thus:
{MERGEFIELD SSN \# "000'-'00'-'0000"}
Press F9 to update the field, then run your merge.

[paul h]

Cheers back at you.

Thanks