Word + Excel + Mail merge = Date Frustration

[Bar]

Hopefully someone can point out the obvious mistake that I must be making.

I have set up an excel spreadsheet to track mail and case files. Created a control sheet within word which will pull in the data from excel and print out control sheets.

Unfortunately I seem to be running into a problem with the date fields.

Within excel I have set the column format as Date - UK. It displays within Excel perfectly. Within word I have set the language as UK default.

When I merge the files the dates go from 18th January 2006 - 01/18/2006. For the love of god I cannot understand why it is doing this.

Any ideas?

 

[Bar]

Just checked and it is

Short format; DD/MM/YYYY

Long Formet: DD MMMMM YYYY

 

[Bar]

Cheers Ric,

Just saved me from killing my PC and everything associated with that spreadsheet.

Did do a google but must have been too simple terms.