How do I convert dates mailmerged out of excel from american forma

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mikek - 03 Oct 2004 22:51 GMT

Merging a date into word document from excel it appears in american format
mm/dd/yyy. How can I convert it to british format dd/mm/yyyy in merged
document

Reply to this Message

Doug Robbins - 04 Oct 2004 01:03 GMT

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Merging a date into word document from excel it appears in american format
> mm/dd/yyy. How can I convert it to british format dd/mm/yyyy in merged
> document

Reply to this Message

Penny - 11 Oct 2004 12:50 GMT

>-----Original Message-----
>Merging a date into word document from excel it appears in american format
>mm/dd/yyy. How can I convert it to british format dd/mm/yyyy in merged
>document
>I'm having same problem with English (Australian). I've

tried formating in it in Excel before merging and the
default in word is is English (Australian) but I haven't
been able to figure out how to fix it yet.

Reply to this Message

Doug Robbins - 11 Oct 2004 16:54 GMT

See my response to the original poster. It provides a link to an article
that will show you how to fix it.

Signature

>
>>-----Original Message-----
[quoted text clipped - 7 lines]
> default in word is is English (Australian) but I haven't
> been able to figure out how to fix it yet.

Reply to this Message