[Drew]

I need Word to format a social security # merge field in this format:
___-__-6789. In other words, I need to hide all but the last 4 digits. My
data source (which I have no contrrol over) is already in SSN format
(123-45-6789). Using \# "___-__-#### gives me the the sum of 123 minus 45
minus 6789.

In a related topic, I need to achieve a similar effect with a mixed (text &
number) field. THe data source has both a name and an SSN. I need it to
dis[play like this: Name Name ___-__-6789. Is this even possible?

Thanks.

[macropod[_2_]]

Hi Drew,

To see how to do this and a wide range of other calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Parse Numbers Separated by + Or - Signs'

--
Cheers
macropod
[MVP - Microsoft Word]


"Drew" wrote in message ...
I need Word to format a social security # merge field in this format:
___-__-6789. In other words, I need to hide all but the last 4 digits. My
data source (which I have no contrrol over) is already in SSN format
(123-45-6789). Using \# "___-__-#### gives me the the sum of 123 minus 45
minus 6789.

In a related topic, I need to achieve a similar effect with a mixed (text &
number) field. THe data source has both a name and an SSN. I need it to
dis[play like this: Name Name ___-__-6789. Is this even possible?

Thanks.