Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging dates to word doc from excel
On only some occassions, when I attempt to merge a date from an Excel sheet
into a work document I get a number e.g the date 2 Feb 07 in excel merges into Word Doc as 39115. It does not always happen. I have checked format in excel - makes no difference anb have used Alt F9 in word (\"@ d MMMM yyyy") - but no luck. Would appreciate some help on this. Thanks. Andrew |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging dates to word doc from excel
You probably have "mixed data types" in your date column in Excel - for
further info. and some solutions, see http://tips.pjmsn.me.uk/t0003.htm and in this case, checking/modifying the data in your column or switching the connection method to DDE will probably work. Peter Jamieson "ecoeng" wrote in message ... On only some occassions, when I attempt to merge a date from an Excel sheet into a work document I get a number e.g the date 2 Feb 07 in excel merges into Word Doc as 39115. It does not always happen. I have checked format in excel - makes no difference anb have used Alt F9 in word (\"@ d MMMM yyyy") - but no luck. Would appreciate some help on this. Thanks. Andrew |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATES KEEP CHANGING TO US FORMAT IN WORD (MERGING) | Mailmerge | |||
Why do dates change from UK to US formats when merging in word | Mailmerge | |||
Merging dates from an access data base to a word document. | New Users | |||
Using IF...Then when merging dates from Access to Word | Mailmerge | |||
Excel Dates formatting in Word | Mailmerge |