Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word07 displays merged date from Excel as serial
I've been reading through the various posts related to this problem, and I'm
thinking the merge is delivering my dates from Excel as text since I have a few header lines at the top of the source file (I've tried the formatting commands in Word to no avail). The only field code options enabled are for text -- uppercase, lowercase, etc. I was just converted to Office 07 so I'm still fumbling around, and I haven't figured out how to force the date in as a number (saw the menu path & info for Word03). I also checked out macropod's massive zip file of date conversions to try and calculate the mm/dd/yy in Word from the text I have, but I don't see any actual code lines in each section of the file, just description. Help? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word07 displays merged date from Excel as serial
I also checked out macropod's massive zip file of date conversions to
try and calculate the mm/dd/yy in Word from the text I have, but I don't see any actual code lines in each section of the file, just description. Help? As with all field stuff, if you use Alt-F9 to toggle field code/field result display you should see the field codes macropod uses. There is also some VBA macro code if you open up the VBA editor. I've been reading through the various posts related to this problem, and I'm thinking the merge is delivering my dates from Excel as text since I have a few header lines at the top of the source file (I've tried the formatting commands in Word to no avail). The only field code options enabled are for text -- uppercase, lowercase, etc. If you have cells above your date cells that do not contain dates, you may well end up with the dates coming across as numbers. AIUI in that case, you can use macropod's field to convert them to dates. Another possibility might be (not sure, and it depends on whether you are adding rows to your data) to insert a heading row immediately above your data, insert a range name that "covers" tha row plus the data rows, then use that as the data sourc. Trouble is that the range name will not necessarily grow/shrink automatically as you add/remove data rows. Peter Jamieson http://tips.pjmsn.me.uk Carol wrote: I've been reading through the various posts related to this problem, and I'm thinking the merge is delivering my dates from Excel as text since I have a few header lines at the top of the source file (I've tried the formatting commands in Word to no avail). The only field code options enabled are for text -- uppercase, lowercase, etc. I was just converted to Office 07 so I'm still fumbling around, and I haven't figured out how to force the date in as a number (saw the menu path & info for Word03). I also checked out macropod's massive zip file of date conversions to try and calculate the mm/dd/yy in Word from the text I have, but I don't see any actual code lines in each section of the file, just description. Help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF then with merged date field from excel | Mailmerge | |||
mail merge from excel-date in excel January 1, 2005 -merged dbase. | Mailmerge | |||
when I merge my data from excel dates are merged as serial number | Mailmerge | |||
Excel serial date formats | Mailmerge | |||
How to correct too much decimals and date if merged from Excel? | Mailmerge |