Date format in Merge field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Challen - 30 Sep 2003 09:31 GMT

Thank you in advance for all help supplied.

I am in the UK. I have my Regional settings in the
control panel set to English UK.

I am trying to Mail Merge data from an Excel spreadsheet
that includes a DATE column. I have the DATE column set
in English format dd/MM/yy. When Merging with Word
document the date defaults to US. MM/dd/yy. I find that
you cannot toggle the field code and put in a "/@" switch
on a merge field. PLEASE PLEASE - how can I set these
dates to UK format.

Thank you

Roy

Reply to this Message

Pete Harrison - 30 Sep 2003 11:34 GMT

Roy,

Not sure if this will fix your problem, but talking with
several support guy's recently, they told me of a problem
with the Regional Settings not properly changing all date
formats internally.

The fix is very easy. Change the regional settings to
something very different to the UK (I picked Estonian).
Shut down your computer. Restart it and change the
settings back to UK English. Shut Down your computer.
Restart it and check that it is UK in the regional
settings then try your merge again.

As I say, this wasn't specifically to do with merging, but
I did find the date formats worked correctly for me.

Regards
Pete

>-----Original Message-----
>Thank you in advance for all help supplied.
[quoted text clipped - 14 lines]
>Roy
>.

Reply to this Message

Doug Robbins - Word MVP - 30 Sep 2003 13:49 GMT

Hi Roy,

See the "Dates: day/month reversed" item under the "Mailmerge in Word 2002"
section of Fellow MVP, Cindy Meister's web site at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Thank you in advance for all help supplied.
>
[quoted text clipped - 12 lines]
>
> Roy

Reply to this Message