| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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 | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I prevent a merged date field from wrapping? | Mailmerge | |||
| inserting a date field for a future date | Microsoft Word Help | |||
| Date issue merging from Excel field in Date format to Word | Mailmerge | |||
| Make merged field bold if merged field is > 3 | Mailmerge | |||
| Make merged field bold if merged field > 3 | Mailmerge | |||
Linear Mode
