Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date field showing as numbers
thanks Doug
that worked a treat! it must be a feature i missed somewhere along the line! john "Doug Robbins - Word MVP" wrote: Change the method of connection to the data source by selecting Options from the Tools menu in Word and then on the General tab, check the Confirm conversions at open item. Then when you attach the data source, try the DDE option in the dialog box that will then appear. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "John M" John wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with Field Codes | New Users | |||
Date functions!!!! | Tables | |||
Word and the Insert Date Created Field | Microsoft Word Help | |||
Mail Merge document and Date field | Mailmerge | |||
Manually edit date in createdate field | Microsoft Word Help |