Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Date in Merge
I am merging from an Excel File into a Word Document.
Everything works except for a date field. I have it formatted as MM/DD/YY in Excel but the merge displays it as YYYY-MM-DD HH:MM:SS What do I need to do to display MM/DD/YY in the merge? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Date in Merge
In your mail merge main document, use Alt-F9 to display the field codes and
modify, e.g. { MERGEFIELD myfield \*Mergeformat } to { MERGEFIELD myfield \@"MM/DD/YY" \*Mergeformat } Peter Jamieson "swimdad16" wrote in message .. . I am merging from an Excel File into a Word Document. Everything works except for a date field. I have it formatted as MM/DD/YY in Excel but the merge displays it as YYYY-MM-DD HH:MM:SS What do I need to do to display MM/DD/YY in the merge? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge fields merge with different formatting | Microsoft Word Help | |||
How do I correct how a birth date shows in a mail merge field? | Mailmerge | |||
Date Field Merge | Mailmerge | |||
Mail merge from Excel file changes date formatting | Mailmerge | |||
using date field in merge | Mailmerge |