Ever wonder how to change the date format of a mail merge field in Word 2010?
Although some might expect the answer to be as simple as changing the format in the originating document, I quickly discovered that is not the case. After spending some considerable time trying to figure this out on my own, once again Google came to the rescue!
Thanks to Paul Edstein (a.k.a. “macropod”) of Microsoft.com and his easy-to-follow steps, I was able to accomplish this task in less than 5 minutes!
Here’s how you do it:
1. Select the merge field you want to change. In this case, it’s the Date field:
2. First, you need to make the field coding visible. To do this, press Shift-F9. The field you selected should now look like this:
3. In the screenshot above, the word “Date” is the merge field’s name. If you see any text after your merge field’s name, delete it now.
4. You’re now ready to change the format. Add a space after your merge field’s name and type the following: \@ “MMMM d, yyyy” Your merge field should now look like this:
Keep in mind that you can change the date format to whatever you like. Other possible formats could be: • dd/MMM/yyyy • d/MMM/yy • d MMMM yyyy
The only thing to remember is that you need to use uppercase M’s to indicate months because lowercase m’s represent minutes.
5. When I was done, my date format went from this:
We’d love to hear from you! If you’ve got any tips or tricks relating to any Microsoft Office program, please feel free to send them on over to email@example.com.
Client Service Coordinator
Sector Learning Solutions