Reply
 
Thread Tools Display Modes
  #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?
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

--

Graham Mayor - Word MVP

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




jmasood wrote:
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I prevent a merged date field from wrapping? Glenn Mailmerge 1 January 26th 05 05:46 PM
inserting a date field for a future date rm Microsoft Word Help 2 January 10th 05 08:18 PM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 08:34 AM
Make merged field bold if merged field is > 3 Vick Mailmerge 3 December 15th 04 03:32 PM
Make merged field bold if merged field > 3 Vick Mailmerge 1 December 13th 04 05:26 PM


All times are GMT +1. The time now is 03:43 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"