Oct 18 2018 02:35 AM
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
Oct 18 2018 02:50 AM
Apr 14 2020 08:50 AM
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