Format SSN to keep leading zero's

M

Manuel

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
 
R

Rich/rerat

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>>


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leading zero's missing for SSN numbers... 3
Text form field number format leading zero 2
AS400 Leading Zero's 3
Number Format in OWC Spreadsheet 7
Formatting numbers with leading and trailing zero's 7
How do I stop Excel from dropping leading zeros? 2
Remove Leading Zero's 3
Email Mail Merge via linked Excel sheet 0

Top