View Single Post
  #1   Report Post  
Helen
 
Posts: n/a
Default Format from Excel not being shown in mail merge

Hi,

I have created a mail merge in Word from an Excel spreadsheet. The
spreadsheet contains social security numbers that are stored as numbers
999999999 but formatted as 999-99-9999. When doing the mail merge Word will
display the SSN as 999999999, not as 999-99-9999. How can I fix this?

Thanks!!

Helen