Mail merge date anomaly

[vegan70]

Hello oh founts of all excel knowledge...

I'm merging from Excel 2007 to Word 2007.
I have two date fields - Start Date and Leave Date.

Both are formatted exactly the same in the Excel Spreadsheet:
Start Date 01 July 2011
Leave Date 11 May 2012

and both have exactly the same switch in the word document:
{MERGEFIELD "Start_Date__"\@ "MMMM d, yyyy" }
{MERGEFIELD "Leave_Date__"\@ "MMMM d, yyyy" }

but although the Start Date comes through as July 1, 2011
the leave date comes through as 41040 instead of May 11, 2012

Please help!

 

[VoG]

Please continue in this thread http://www.mrexcel.com/forum/showthread.php?t=584959

Having two threads open on the same subject will lead to confusion.