Format SSN to keep leading zero's Manuel 10/29/2008 12:44:00 AM I’d like to format the SSN so that mail merge does not drop the leading zero's. Currently I’m using the following switch: {MERGEFIELD SEC_MORTGAGOR_SS_NUMBER\# ###'-'##'-'####}. While the switch does insert the dashes any leading zero's are dropped. So, 012345678 becomes 12-34-5678 (I want the field to format as 012-34-5678). Any suggestions? Thanks, Manuel

Re: Format SSN to keep leading zero's "Rich/rerat" <rrr_news[ at ]isp.com> 10/29/2008 1:41:19 AM Manuel, Change: {MERGEFIELD SEC_MORTGAGOR_SS_NUMBER\# ###'-'##'-'####} TO: {MERGEFIELD SEC_MORTGAGOR_SS_NUMBER \# "000'-'00'-'0000"} -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> "Manuel" <Manuel[ at ]discussions.microsoft.com> wrote in message news:FBE9FFCC-492B-40E3-9B3A-C4F496DF0DAD[ at ]microsoft.com... I’d like to format the SSN so that mail merge does not drop the leading zero's. Currently I’m using the following switch: {MERGEFIELD SEC_MORTGAGOR_SS_NUMBER\# ###'-'##'-'####}. While the switch does insert the dashes any leading zero's are dropped. So, 012345678 becomes 12-34-5678 (I want the field to format as 012-34-5678). Any suggestions? Thanks, Manuel