SanjayaGarg
New Member
- Joined
- Nov 10, 2017
- Messages
- 25
- Office Version
- 2013
- Platform
- Windows
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 a cell where date is calculated,
e.g.
When date field is merged from C2, date is shown as numbers even after adding switches.
Can this be rectified.
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 a cell where date is calculated,
e.g.
A | B | C | D | |
1 | TENURE | DOJ | DUE DATE | FORMULA IN C2 |
2 | 44 | 16-05-2020 | 29-06-2020 | =DATE(YEAR(B2),MONTH(B2),DAY(B2)+A2) |
When date field is merged from C2, date is shown as numbers even after adding switches.
Can this be rectified.