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

[mikek]

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

 

[Doug Robbins]

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


--
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

 

[Penny]

-----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.

 

[Doug Robbins]

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

--
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