Formatting Mail Merged Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MAB - 14 Jan 2008 22:08 GMT

I’m merging information from an Excel document into a Word document, and I
have a question about date formats.

I know formatting isn't retained when data is merged into a document, so I’d
like to know how to display the Excel date "December 7, 2007” as "12/07” in
the Word document.

I’m using Office 2003 products.

Thank you.

Reply to this Message

Doug Robbins - Word MVP - 15 Jan 2008 02:47 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm merging information from an Excel document into a Word document, and I
> have a question about date formats.
[quoted text clipped - 7 lines]
>
> Thank you.

Reply to this Message