How to edit the ouput of a ssn mergefield from 123-45-6789 to - Microsoft Community

hello...

looking way edit output of ssn merge field create xxx-xx-6789 on document... rather 123-45-6789.

i did other googling , coming result on internet:

************************************

right-click ssn merge field , select toggle field codes popup menu.
you'll see this:

{ mergefield "ssn" }

or

{ mergefield "ssn" \* mergeformat }

ssn name of merge field. edit field code this:

{ mergefield "ssn" \# "'xxx-xx-'x0000" }

press f9 hide field code , update result.

**************************

my field this:

{ mergefield providerdemographics.ssn \# " 'xxx-xx-'x0000" }

i trying follow suggstions of found on internet on message board.  and... it's not working.  have error in syntax.  it?

thanks!

in application data source?  best manipulation in data source.

if excel, in adjacent column, use "xxx-xx-"& right([cellref], 4)

Office / Word / Other/unknown / Office 2010