Word 2007 - Mail merge dates showing in US and not UK format
-
Friday, June 29, 2012 9:41 AM
Hi, I've had this problem before when I do a mail merge where the dates in the merge document appear in the US format and not the UK one, but I can't remember how to rectify it. I want the dates to appears as DD/MM/YYYY and not MM/DD/YYYY.
Can anyone refresh my memory please?
Thansk, Viv
Viv Haig
- Changed Type Max MengMicrosoft Contingent Staff, Moderator Monday, July 02, 2012 1:41 AM
All Replies
-
Friday, June 29, 2012 12:18 PM
Open the document with the mail merge fields.
Right-click the date merge field, and select Toggle Field Codes from the context menu.
You will see something like { MERGEFIELD DateField } or { MERGEFIELD DateField \* MERGEFORMAT }, where DateField is the name of the merge field.
Make it look like this: { MERGEFIELD DateField \@ "dd/MM/yyyy" }
Press F9 to hide the field code.
Regards, Hans Vogelaar
- Marked As Answer by Jaynet ZhangMicrosoft Contingent Staff, Moderator Monday, July 02, 2012 2:05 AM
-
Saturday, June 30, 2012 8:06 AMFantastic. Many thanks Hans.
Viv Haig
-
Monday, July 02, 2012 2:07 AMModerator
Hi,
Thank you for posting.
And also thanks, Hans, to resolve the issue.
It will help others who meet the same issue.
Jaynet Zhang
TechNet Community Support
.png)
