date format in mail merge

[SanjayaGarg]

Dear all

I have a mail merge word document which fetches its data from excel sheet and shows date format correctly after adding switch <\@ "dd/MM/yyyy"> in date field of word documents. Now the problem arise when data is fetched from another sheet where data is inserted from multiple sheets through simple formula eg. <='sheet1'!A20>, <='sheet2'!b20> etc. When date field is merged from this formula sheet, date is shown as numbers even after adding switches. Can this be rectified.