How to prevent Merged Date Field showing time?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jmasood - 21 Feb 2005 10:35 GMT

I have some data in Excel file and the date field in Excel file has a pure
date format "dd/mm/yy" however when I use MS Word 2002 Mail Merge I get the
date as "dd/mm/yyyy 12:00:00 AM" The date is shown correctly in Excel but
changes to different format in Word.

Windows default date display is set for dd/mm/yy.

How can I prevent showing of time in the merged document?

Reply to this Message

Graham Mayor - 21 Feb 2005 11:59 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have some data in Excel file and the date field in Excel file has a
> pure date format "dd/mm/yy" however when I use MS Word 2002 Mail
[quoted text clipped - 4 lines]
>
> How can I prevent showing of time in the merged document?

Reply to this Message