Date field formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anthony Cupit - 31 Aug 2004 11:14 GMT

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.

Reply to this Message

Doug Robbins - 01 Sep 2004 00:52 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

>I am using a merge field to put a date into a Word
> document. The format on the excel sheet is dd/mm/yyyy.
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message