Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting Date in Mail Merge
I have a swim team roster in Excel 2003. One of the fields is birthdate
formatted as a date mm/dd/yy. When I merge that field using Word 2003 the date shows up as yyyy-mm-dd 00:00:00 How can I change the format to mm/dd/yy or mm/dd/yyyy? Thanks! |
#2
|
|||
|
|||
You have to add a date formatting switch to the merge field:
{ Mergefield Birthday \@ "MM/dd/yy" } Alt+F9 to show/hide the field codes. -- Cindy "Chuck" wrote: I have a swim team roster in Excel 2003. One of the fields is birthdate formatted as a date mm/dd/yy. When I merge that field using Word 2003 the date shows up as yyyy-mm-dd 00:00:00 How can I change the format to mm/dd/yy or mm/dd/yyyy? Thanks! |
#3
|
|||
|
|||
Thanks Cindy. It worked exactly as you described!
"Cindy Meister" wrote in message ... You have to add a date formatting switch to the merge field: { Mergefield Birthday \@ "MM/dd/yy" } Alt+F9 to show/hide the field codes. -- Cindy "Chuck" wrote: I have a swim team roster in Excel 2003. One of the fields is birthdate formatted as a date mm/dd/yy. When I merge that field using Word 2003 the date shows up as yyyy-mm-dd 00:00:00 How can I change the format to mm/dd/yy or mm/dd/yyyy? Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Using Date Filters With SQL Data Source | Mailmerge | |||
How do I control date formatting in a Word Mail Merge? | Mailmerge | |||
How to remove unwanted formatting in mail merge for cells witn no | Mailmerge | |||
English/American date formatting in XP mail merge | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |