After perusing past posts I found one by "AtCollege" which pointed to the answer.
I'll paste it below. Thanks AtCollege.
-------------------------------------------
Display Formatted #'s from Excel in a Word Mail Merge
The solution starts in Word. Go to Tools, Options, General tab. Check Confirm Conversion at Open. OK.
This is a permanent change in Word and you should only have to do it once.
In Excel, format dates and numbers the way you want them to appear in Word.
Back in Word's Mail Merge Wizard, Browse for the Excel recipient list. When it is opened, you will be prompted for the type of connection. Look for something with DDE in it. Once you select that, you will have to say what sheet, etc. to use. But then any fields which contain dates, numbers will display the formatting you chose in Excel.
This "problem" started in Word XP, I think. Microsoft has a knowledge base article about it. Word 2007 also has the same "feature".
Posted: 06/20/2007 @ 10:11 AM (PDT)
AtCollege 1
Job Role: Technical/PC Support
Location: Elizabethtown, PA
Member since: 08/03/2004