Merge Fields Date Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Geri - 29 Oct 2007 11:27 GMT

Hi there, I'm trying to merge an Excel document into Word and the date format
is coming up americanised, ie mmddyy, I prefer the UK date format of ddmmyy,
I've tried to rectify this thr using Shift F9, however the date is coming up
as ddmmyy, however via the merge it is changing of its own accord is there a
known bug or any way to repair this, the versions I'm using are;

Word 2003 SP2
Excel 2003 SP2
XP Pro 2002 SP2

Oh just in case the data source in Excel has the UK date format of ddmmyy too

Thanks
Geri

Reply to this Message

Graham Mayor - 29 Oct 2007 11:39 GMT

Use a date switch on the merge field - see
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi there, I'm trying to merge an Excel document into Word and the
> date format is coming up americanised, ie mmddyy, I prefer the UK
[quoted text clipped - 12 lines]
> Thanks
> Geri

Reply to this Message

Nicky31 - 05 Nov 2007 13:32 GMT

Hi Geri
I was just wondering if you did manage to rectify this problem, as I've
encountered it too and if so, a simple explaination of how you did it would
be really helpful!
Thanks,
Nicky

> Hi there, I'm trying to merge an Excel document into Word and the date format
> is coming up americanised, ie mmddyy, I prefer the UK date format of ddmmyy,
[quoted text clipped - 10 lines]
> Thanks
> Geri

Reply to this Message

Peter Jamieson - 05 Nov 2007 15:36 GMT

Can you please try to look through the various replies to the three
conversations Geri has started on this subject since mid-October and see if
any of the suggestions made in there help? I would also be interested to
hear from Geri whether the problem is now solved - if not, it may be that
there are situations in which none of the various suggestions work, and if
so it would be worth further investigation.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hi Geri
> I was just wondering if you did manage to rectify this problem, as I've
[quoted text clipped - 23 lines]
>> Thanks
>> Geri

Reply to this Message

Geri - 21 Nov 2007 16:34 GMT

Hi Geri, here I'm still working my way through all of the suggestions, I'll
be more than glad when I find one that works, glad to hear I'm not the only
person with this problem!

Geri

> Can you please try to look through the various replies to the three
> conversations Geri has started on this subject since mid-October and see if
[quoted text clipped - 30 lines]
> >> Thanks
> >> Geri

Reply to this Message

Geri - 21 Nov 2007 17:34 GMT

Hi Nicky, I've managed to look through all the posts and the one from Doug
works a treat, so I cut and past his reply for you click on the link and
follow steps 1 to 6 in your excel document then perform the merge fingers
crossed it will work for you too.

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

A BIG THANK YOU FOR ALL YOUR HELP to Doug, Peter, Graham and Macropod from
Geri

> Hi Geri
> I was just wondering if you did manage to rectify this problem, as I've
[quoted text clipped - 17 lines]
> > Thanks
> > Geri

Reply to this Message