[Graham Mayor]

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

--

Graham Mayor - Word MVP

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


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