Change Mail Merge Date Format from US to UK

Evanaught · #1 09-06-2013, 06:03 AM

Hi,

When I merge the data source with the document, the date format changes from UK format: 25/01/1984 (as it is entered in the Excel data source), to the US format: 01/25/1984, when it appears in the document. It's a big problem, as I'm creating multiple documents and I can't keep manually changing it everytime I need to. Very time consuming!

Is it possible to change the format?? I've tried just about everything (or so I think...)

Your help would be much appreciated

Evan

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
mail merge treating CITY as DATE	woody	Mail Merge	6	01-30-2013 03:22 PM
Issue with date format in mail merge document	walshjod	Mail Merge	4	11-28-2012 04:46 AM
Change format of date when using Now function in VB code	Bondai	Excel Programming	2	03-02-2012 05:09 PM
Mail merge will not format date field generated by Excel IF statement	borntorun75	Mail Merge	3	12-16-2011 06:28 AM
Date not transfering to mail merge correctly	tonywatsonmail	Mail Merge	1	07-01-2011 05:30 AM