Formatting Date in Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

swimdad16 - 23 May 2006 15:24 GMT

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 to this Message

Peter Jamieson - 23 May 2006 17:58 GMT

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

>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 to this Message