Kalindi has attended:
Excel Intermediate course
Excel Advanced course
Access Intermediate course
UK date format
I get month/date/year in date format when I do mail merge but I want date/month/year in date format, how do I go about it.
Many thanks
Kalindi
RE: UK date format
Hi Kalindi,
Thank you for the forum question.
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.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector