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/cindy...r/MergFram.htm
THANX DOUG
A BIG THANK YOU FOR ALL YOUR HELP to Doug, Peter, Graham and Macropod from
Geri
"Nicky31" wrote:
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
"Geri" wrote:
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