Thread: [Solved] Problem with formating
View Single Post
 
Old 05-07-2019, 04:42 AM
Stax82 Stax82 is offline Windows 10 Office 2019
Novice
  
Join Date: Apr 2019
Posts: 2
Stax82 is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
You should get the desired result just by omitting the field switch; otherwise, see Mailmerge US Social Security Number Formatting in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
If I omit the field switch \# ########'-'#### then i got the a decimal number 1,#########e+11 for the SSN's without a T in them.
Reply With Quote