Date problem in Word mail merge from Excel
Posted on 2007-11-20
My colleague has created an Excel workbook containing customer information with a start- and end date for contracts.
These columns are formatted as date cells in the Dutch format dd-MM-yyyy.
She's now trying to create a Word mail merge letter with these fields. The start date shows up fine, but the end date is in a US format (MM-dd-yyyy). We tried to alter the merge field with the switch @\ "dd-MM-yyyy", but it doesn't work.
The only end dates that are correctly displayed are the ones after the 12th day of the month (e.g. 20-11-2007), so it looks like Word is applying the correct date format, but identifies the dates from the Excel workbook incorrectly.