Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Carol Carol is offline
external usenet poster
 
Posts: 82
Default 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?

 
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
IF then with merged date field from excel Holly Mailmerge 3 January 14th 06 07:05 AM
mail merge from excel-date in excel January 1, 2005 -merged dbase. Elaine Ballon Mailmerge 1 December 23rd 05 08:31 AM
when I merge my data from excel dates are merged as serial number Graham Mailmerge 1 December 19th 05 06:13 AM
Excel serial date formats BarbH Mailmerge 3 August 20th 05 04:20 AM
How to correct too much decimals and date if merged from Excel? Stefanus Mailmerge 1 July 15th 05 08:00 PM


All times are GMT +1. The time now is 07:12 AM.

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"