Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I stop Mail Merge from changing dates to USA format
I have Excel & Word 2003.
I have created an Excel database with dates stored in Australian format ie DD/MMM/YY When I merge this into a word document it converts the dates to USA format ie MM/DD/YY. How do I stop this from occuring? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I stop Mail Merge from changing dates to USA format
Use a date switch on your date field -
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 Jan Wachowski wrote: I have Excel & Word 2003. I have created an Excel database with dates stored in Australian format ie DD/MMM/YY When I merge this into a word document it converts the dates to USA format ie MM/DD/YY. How do I stop this from occuring? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I stop Mail Merge from changing dates to USA format
Hi
I'm almost computer illiterate so didn't understand a word of Graham's site (Thanks anyway Graham!) Anyway, my brother got me around the problem of Americans and their rubbish inability to do things properly like the rest of the world.. Copy the Excel sheet into word and then use that as your file for importing into the mail merge. It doesn't solve the problem but it does bypass it. -- vetondenet "Jan Wachowski" wrote: I have Excel & Word 2003. I have created an Excel database with dates stored in Australian format ie DD/MMM/YY When I merge this into a word document it converts the dates to USA format ie MM/DD/YY. How do I stop this from occuring? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I stop Mail Merge from changing dates to USA format
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 "vetondenet" wrote in message ... Hi I'm almost computer illiterate so didn't understand a word of Graham's site (Thanks anyway Graham!) Anyway, my brother got me around the problem of Americans and their rubbish inability to do things properly like the rest of the world.. Copy the Excel sheet into word and then use that as your file for importing into the mail merge. It doesn't solve the problem but it does bypass it. -- vetondenet "Jan Wachowski" wrote: I have Excel & Word 2003. I have created an Excel database with dates stored in Australian format ie DD/MMM/YY When I merge this into a word document it converts the dates to USA format ie MM/DD/YY. How do I stop this from occuring? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I stop Mail Merge from changing dates to USA format
Anyway, my brother got me around the problem of
Americans and their rubbish inability to do things properly like the rest of the world.. Gee, what on earth do you mean? I'm not an American, but... ....you mean like Europeans nearly destroyed themselves twice in the 20th century and were baled out by Americans who sacrificed their lives even though they didn't really have to? Or you mean like someone in Europe invented A1/A2/A3 paper sizes? That kind of important thing? Or what? Peter Jamieson |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I stop Mail Merge from changing dates to USA format
Dear Doug,
Never visited this site since you gave that suggestion so apologies for the delay in thanking you. Works perfectly! Thanks again -- vetondenet "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 "vetondenet" wrote in message ... Hi I'm almost computer illiterate so didn't understand a word of Graham's site (Thanks anyway Graham!) Anyway, my brother got me around the problem of Americans and their rubbish inability to do things properly like the rest of the world.. Copy the Excel sheet into word and then use that as your file for importing into the mail merge. It doesn't solve the problem but it does bypass it. -- vetondenet "Jan Wachowski" wrote: I have Excel & Word 2003. I have created an Excel database with dates stored in Australian format ie DD/MMM/YY When I merge this into a word document it converts the dates to USA format ie MM/DD/YY. How do I stop this from occuring? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge format fields | Mailmerge | |||
DATES KEEP CHANGING TO US FORMAT IN WORD (MERGING) | Mailmerge | |||
Mail merge - how to stop SQL msg on merged docs | New Users | |||
Mail Merge date format problem with Word 2003 | New Users | |||
Mail Merge - Date Format | Microsoft Word Help |