Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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? :-( |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel - word mailmerge dates wrong...
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 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Dwill" wrote in message ... 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? :-( |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assistnace with mailmerge dates from excel | Mailmerge | |||
Mailmerge calculated dates from Excel | Mailmerge | |||
Word Mailmerge reading UK dates in Access as US dates | Mailmerge | |||
Mailmerge Dates | Mailmerge | |||
Word 2002 Mailmerge-gives wrong font size | Microsoft Word Help |