Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Very strange Excel to Word date conversion
I have an Excel spreadsheet with three columns of dates. All three columns
are formatted in Excel exactly the same way (10-Feb-2008) The first and third column are showing up in the Word merge document AND in the Mail Merge Recipients window as a serial date. The second column is showing up in the Recipients window as a date, but not in the right format (2/10/2008). I set a switch code in the date fields to force the date format I need, but (obviously) am having no luck. Help???? This one is showing up as "39488" {MERGEFIELD "PROCESS_START_DATE" \@ "dd MMM yyyy" } This one is showing up as "2/10/2008" {MERGEFIELD "ACTUAL_SURVEY_DATE" \@ "dd MMM yyyy" } |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word converts English date to USA date in mail-merge from Excel? | Mailmerge | |||
Strange behaviour of date fields in Excel-Word mailmerge | Mailmerge | |||
Conversion of an Excel 200 document into Word 2000 | Microsoft Word Help | |||
Word/Excel Conversion? | Microsoft Word Help | |||
Date issue merging from Excel field in Date format to Word | Mailmerge |