Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how do i stop mailmerge date format mm showing as 00
On merging from excel and access the date fields are changed from UK to US
format. i have altered the field codes using \@ "dd/MM/yy" the day and year changed fine but the month is displayed as 00. how can i get the date to stop converting to US format or show in UK format DD/MM/YY? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how do i stop mailmerge date format mm showing as 00
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 "Brian M" Brian wrote in message ... On merging from excel and access the date fields are changed from UK to US format. i have altered the field codes using \@ "dd/MM/yy" the day and year changed fine but the month is displayed as 00. how can i get the date to stop converting to US format or show in UK format DD/MM/YY? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing Date Format Upon Mailmerge | Mailmerge | |||
Mailmerge date format | Mailmerge | |||
US / English date format mailmerge | Mailmerge | |||
convert date format after mailmerge | Mailmerge | |||
Mailmerge changing date format | Mailmerge |