Problem with date formatting in mail merge

%3CLINGO-SUB%20id%3D%22lingo-sub-275198%22%20slang%3D%22en-US%22%3EProblem%20with%20date%20formatting%20in%20mail%20merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275198%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I'm%20trying%20to%20pull%20a%20date%20mergefield%20through%20into%20a%20word%20document.%26nbsp%3B%20It%20has%20worked%20for%20me%20before%20so%20I%20can't%20work%20out%20what%20has%20changed.%3C%2FP%3E%3CP%3EThe%20date%20on%20the%20excel%20spreadsheet%20is%20in%20short%20date%20format%20dd%2FMM%2Fyyy%3C%2FP%3E%3CP%3EThis%20is%20what%20i%20use%20in%20the%20word%20document%2C%20this%20was%20copied%20from%20MS%20help%20%3CSPAN%3E%7B%20MERGEFIELD%26nbsp%3BDate-paid%20%5C%40%20%22d%20MMMM%20yyyy%22%20%5C*MERGEFORMAT%20%7D%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Eand%20it%20returns%20this%2043391%26nbsp%3B%20In%20fact%20i%20just%20copied%20it%20from%20my%20word%20document%20to%20put%20it%20in%20here%20and%20that%20is%20what%20appeared.%20Even%20without%20the%20%5C*MERGEFORMAT%20it%20still%20doesn't%20work.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%20i%20know%20it's%20kind%20of%20working%20because%20this%20seems%20to%20be%20the%20date%20come%20through%20but%20in%20'general'%20format%20even%20though%20on%20the%20excel%20spreadsheet%20it%20is%20formatted%20as%20date.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECan%20anyone%20help%20please%2C%20this%20is%20most%20frustrating!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20Mary%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-275198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275204%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20date%20formatting%20in%20mail%20merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275204%22%20slang%3D%22en-US%22%3EEven%20weirder%2C%20there%20is%20another%20excel%20spreadsheet%2C%20part%20of%20the%20same%20workbook%2C%20identical%20layout.%20When%20i%20connect%20that%20one%20to%20my%20letter%20the%20date%20comes%20through%20fine.%20there%20is%20nothing%20different%20about%20the%20formatting%20in%20the%20same%20date%20column%20on%20each%20spreadsheet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1306173%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20date%20formatting%20in%20mail%20merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1306173%22%20slang%3D%22en-US%22%3E%3CP%3EI%20create%20another%20column%20in%20Excel%20and%20use%20a%20formula%20like%20%22%3DTEXT(A1%2C%22D%20MMMM%2C%20YYYY%22)%22%20then%20I%20insert%20that%20field%20into%20the%20Word%20document%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi I'm trying to pull a date mergefield through into a word document.  It has worked for me before so I can't work out what has changed.

The date on the excel spreadsheet is in short date format dd/MM/yyy

This is what i use in the word document, this was copied from MS help { MERGEFIELD Date-paid \@ "d MMMM yyyy" \*MERGEFORMAT } 

and it returns this 43391  In fact i just copied it from my word document to put it in here and that is what appeared. Even without the \*MERGEFORMAT it still doesn't work.

 

So i know it's kind of working because this seems to be the date come through but in 'general' format even though on the excel spreadsheet it is formatted as date.

 

Can anyone help please, this is most frustrating!

Thanks Mary 

2 Replies
Highlighted
Even weirder, there is another excel spreadsheet, part of the same workbook, identical layout. When i connect that one to my letter the date comes through fine. there is nothing different about the formatting in the same date column on each spreadsheet.
Highlighted

I create another column in Excel and use a formula like "=TEXT(A1,"D MMMM, YYYY")" then I insert that field into the Word document