Excel/Word turning months into "00". How do I fix this?

[MACKENZI]

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?

[oeldere]

show us an excel file, without confidentional information.

please also add the desired (expected) result.

[MACKENZI]

I don't ever use Excel. The Results Plus program has a Mail Merge Wizard that has the date "MM/dd/yyyy" selected. The Word document is already created with a "hdr" word file linked. So when the "John Smith Convention.dotx" is created as a mail merge word file, a header file "John Smith Conventionhdr.dotx" is automatically created & linked.

[oeldere]

Please Login or Register  to view this content.

The text in your title refers also to excel.

With your question about WORD, i can't help you enough.

[MACKENZI]

It pulls an Excel table into a Word document.

[MACKENZI]

Here is the table in an Excel spread sheet. The Word document has a table with the same header names.

[oeldere]

In excel it is possible to change your format of months (and days), but as you already said, you don't show which month it is.(00 8, 2013)

[MACKENZI]

Every month show up with (00), it could be January or 11 other months, and I am totally stumped. It's through a SQL Server, if that helps any.

[MACKENZI]

Is there anyone that can help me out?