Date field showing as numbers
hi guys
hopefully someone can help here
office 2003
i have an excel spreadsheet with a calculated date field in , field
formatted as date in excel and displays fine.
when mailmerged into Word the field reverts back to a number and using the
merge field switches ALT-F9 makes no difference,updating the field and saving
and reopening the document also makes no difference.
the field is: {MERGEFIELD M_8_WEEKS \@ "dd/MM/yy"}
shows as March 11 2006 in Excel but 38787 in Word
the calculated field in Excel takes the date from one cell and simply adds a
number of day from another
anyone any clues as to what im doing wrong?
cheers!
john
|