Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date issue merging from Excel field in Date format to Word
When I merge from Excel to Word with a date field, I get the date listed as
38018 instead of 2/1/2004. What should I do to get it to display properly. The date is formatted as m/dd/yyyy in Excel and I've added the following field switch to the merge date field in Word \@ "MM/dd/yyyy" Any suggestions? |
#2
|
|||
|
|||
See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm and in
particular the Excel data section and the alternative method of connecting to the data file for Word 2002 and 2003. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Barb Reinhardt wrote: When I merge from Excel to Word with a date field, I get the date listed as 38018 instead of 2/1/2004. What should I do to get it to display properly. The date is formatted as m/dd/yyyy in Excel and I've added the following field switch to the merge date field in Word \@ "MM/dd/yyyy" Any suggestions? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help | |||
WP Delay Code - Word Equiv | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help | |||
Word Field Codes in Excel data file | Mailmerge |