I am exporting data in from a different program (Results Plus), into a Word 2010 mail merged document with a header file attached. The header file is an Excel table of my merged fields. I have gone through all the steps to make sure it's not that software. Now I still cannot figure out why all of my months are turning into "00" in a Word mail merge. I have tried \@ "MM/dd/yyyy" and it end ups flipping the month and day around.

For example: it should be January 8, 2013. It shows up originally in my document as "00 8, 2013". When I add the [switch] \@ "MM/dd/yyyy" it shows up as, "08/01/2013". When I tested it out and put "MMMM/dd/yyyy" it shows up as August 1, 2013 instead of what it should be, January 8, 2013.

I have checked my default language (English US).

How do I stop this?