mail merge change the format of the date

[lezawang]

Hi I am not sure if this excel or word issue. I have a column in excel which has dates formatted as below. When I mail merge to word, I loss the format and the date will convert to something like that 30/09/20, instead of the format below. Why is that. Thank you so much.


[TABLE="class: grid, width: 249"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Monday, September 30, 2019[/TD]
[/TR]
[TR]
[TD]Tuesday, October 01, 2019[/TD]
[/TR]
[TR]
[TD]Wednesday, October 02, 2019[/TD]
[/TR]
[TR]
[TD]Thursday, October 03, 2019[/TD]
[/TR]
[TR]
[TD]Friday, October 04, 2019[/TD]
[/TR]
[TR]
[TD]Monday, October 07, 2019[/TD]
[/TR]
[TR]
[TD]Tuesday, October 08, 2019[/TD]
[/TR]
[TR]
[TD]Wednesday, October 09, 2019[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Excel is just sending the data over to Word, not the formatting.
You need to format it on the Word side.
See: https://knowledgecenter.zuora.com/C..._Define_the_Format_for_Date_and_Number_Fields