Numbers Don't Merge Correctly in Word

If you are having a problem with numbers losing their formatting when merging from Excel into Word follow the steps below:

1. After preparing the Word document you are using for a mail merge,
Go to Tools>Options>General Tab
2. Put a check mark in Confirm conversion at open
3. Click OK
4. Start your Mail Merge by going to Tools> Letters and Mailings>Mail Merge
5. Go through the Mail Merge Wizard
6. At the step in the mail-merge process when you connect to your data file, after you locate the Excel worksheet you want to connect to, the Confirm Data Source dialog box opens. Click MS Excel Worksheets via DDE (*.xls) , and then click OK .

7 . Another dialog box will open, Named or cell range , select the cell range or worksheet that contains the information you want to merge, and then click OK .
8. Follow the steps to complete the rest of your mail merge.
9. You will notice all of your numbers have kept their formatting
10. After you have completed your mail merge go to Tools>Options>General Tab
11. Turn off Confirm conversion at Open
12. Click OK