Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
UK dates lose format with Mail Merge
My data in Excel includes a column of dates which have been formatted for UK
English. When I mailmerge this data the dates change format to the US reverse number format, e.g. 20 July 2006 becomes 7/20/2006. How can I preserve UK format? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
UK dates lose format with Mail Merge
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 "DGEB" wrote in message ... My data in Excel includes a column of dates which have been formatted for UK English. When I mailmerge this data the dates change format to the US reverse number format, e.g. 20 July 2006 becomes 7/20/2006. How can I preserve UK format? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
UK dates lose format with Mail Merge
Thanks for referring me to the Meister site which looks very interesting. I
was able to solve my problem by formatting dates as text (as suggested). "Doug Robbins - Word MVP" wrote: 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 "DGEB" wrote in message ... My data in Excel includes a column of dates which have been formatted for UK English. When I mailmerge this data the dates change format to the US reverse number format, e.g. 20 July 2006 becomes 7/20/2006. How can I preserve UK format? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep mail merge format from 2000 when using 2003! | Mailmerge | |||
Mail Merge Date Format Problems | Microsoft Word Help | |||
After using Mail Merge, my new emails have envelope format. | Microsoft Word Help | |||
How keep my Word format when I mail merge to email? | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |