Date field formats

[Anthony Cupit]

I am using a merge field to put a date into a Word
document. The format on the excel sheet is dd/mm/yyyy.
However, when I merge the document it comes out as
mm/dd/yyyy. The regional settings are set to the UK. Any
ideas as to how to prevent this?

Thanks.

 

[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