View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dwill Dwill is offline
external usenet poster
 
Posts: 1
Default Excel - word mailmerge dates wrong...

Hello

I have recently notice an annoying fault or feature :-)


When I do a merge from Excel to Word, the date seems to be have been
changed to mmddyy and not the ddmmyy I want.


I'm using Word and Excel 2003
PC is set to Uk with the date format correct
Excel date column is formatted to show ddmmyy
Word language is set to UK

------------------------------------------

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx


The article nearly got me there...

The code looks like this now {mergefield "DoB" \@ "dd/mm/yy"} but the
month shows as 00 in the Word doc, day and Year is correct (25/00/73)


any pointers?


:-(