I have to merge data from an Excel spreadsheet into Word documents. The Excel spreadsheet is downloaded from a database and the columns with date of birth and passport expiry dates, whilst they look like dates, are in fact text fields. Formatting the columns as date cells makes no difference to the cells. When I created the Word template for the letters I need, I've toggled the date of birth and expiry fields in the template to ensure they appear as dd-MMM-yyyy. However this only works for any date that in Excel appears as the 13th of the month or higher. If the date is the 12th of the month or lower, it then appears in the mail merged document in US date format. So, 14/12/1985 will appear as 14 Dec 1985; 11/12/1985 will appear as 12 November 1985.
My current work-around is to add an extra columns in the Excel spreadsheet and apply the formula =TEXT(P2,"dd mmmm yyyy"). I then have to remove the toggle in the mail merge Word template.
Is there an easier way of doing this? Thanks.
My current work-around is to add an extra columns in the Excel spreadsheet and apply the formula =TEXT(P2,"dd mmmm yyyy"). I then have to remove the toggle in the mail merge Word template.
Is there an easier way of doing this? Thanks.
