Word + Excel + Mail merge = Date Frustration

Bar

Bar

Bar

Soldato
Joined
9 Apr 2004
Posts
2,694
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?
 
Try setting the default system date:

Control Panel->Regional Settings->Regional Options Tab->Customize->Date Tab->Set the format there
 
ok a quick google:
"To switch the date back to UK format you have to use the Format Merged Data using switch formatting on all date fields. If you Alt and F9 you will see the MergeFormat Field on your Word document. If you type \@"dd/MM/yyyy" at the end of the field the date is displayed in that format. NB type as seen i.e with quote marks and the month format must be in upper case for it to work."
 
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.
 
You must log in or register to reply here.
Back
Top Bottom