Change US date to UK date in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Curly Worly - 19 Feb 2008 11:24 GMT

I have created a mail merge document from excel spreadsheet. The date format
in excel is UK format (dd/mm/yyyy). When merging the date field in word it
changes to US date format (mm/dd/yyyy). Word has been installed in UK
version and the operating system is in UK format. How can I change the date
in word merge document from US to UK?

Thanks

Reply to this Message

Graham Mayor - 19 Feb 2008 15:15 GMT

Is your copy of Word fully updated? If so see the section on reversed dates
at http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have created a mail merge document from excel spreadsheet. The
> date format in excel is UK format (dd/mm/yyyy). When merging the
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message