Question: how to change date format in excel for mail merge?
Answer: To format a date merge field, use the \@ switches. For example, to display a date field as "03/30/2010", the merge field should be defined as { MERGEFIELD myObject. myField \@ MM/dd/yyyy} .