Formatting a date field in a mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harold Roundhouose - 27 Sep 2004 00:19 GMT

I am having trouble formatting a date when I perform a merge. I have an
Excel source file with a field called "Renewal Date". In Excel, the date is
stored as 9/12/2004. When the merge is complete in Word, I would like it to
display as "09/12/04". Does anyone know how to accomplish this?

Reply to this Message

Doug Robbins - 27 Sep 2004 01:03 GMT

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

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

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am having trouble formatting a date when I perform a merge. I have an
> Excel source file with a field called "Renewal Date". In Excel, the date
> is
> stored as 9/12/2004. When the merge is complete in Word, I would like it
> to
> display as "09/12/04". Does anyone know how to accomplish this?

Reply to this Message

Rate this thread: