Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date Format from Excel Field
Hi all,
Sorry about the subject line I'm using mail-merge to produce daily signing in sheets. Mail merge fields are just day of the week and date. Start date can be entered on an excel sheet and subsequent days and dates fill in using a formula. My problem is that even though I've changed the format to custom ddmmyy (or something like that) it's displaying in the merge field as 03/06/2007. Any ideas please? -- Smudge |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date Format from Excel Field
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 "Smudge" wrote in message news Hi all, Sorry about the subject line I'm using mail-merge to produce daily signing in sheets. Mail merge fields are just day of the week and date. Start date can be entered on an excel sheet and subsequent days and dates fill in using a formula. My problem is that even though I've changed the format to custom ddmmyy (or something like that) it's displaying in the merge field as 03/06/2007. Any ideas please? -- Smudge |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date Format from Excel Field
Many thanks it worked a treat!
-- Smudge "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 "Smudge" wrote in message news Hi all, Sorry about the subject line I'm using mail-merge to produce daily signing in sheets. Mail merge fields are just day of the week and date. Start date can be entered on an excel sheet and subsequent days and dates fill in using a formula. My problem is that even though I've changed the format to custom ddmmyy (or something like that) it's displaying in the merge field as 03/06/2007. Any ideas please? -- Smudge |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date field in Excel loses format in Word merge | Mailmerge | |||
Date Field Format | Microsoft Word Help | |||
Format the field of DATE | Mailmerge | |||
date field format | Mailmerge | |||
Date issue merging from Excel field in Date format to Word | Mailmerge |