| 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 | |||
Linear Mode
