View Single Post
  #1   Report Post  
jmasood
 
Posts: n/a
Default How to prevent Merged Date Field showing time?

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?