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.

Monday, September 30, 2019

Tuesday, October 01, 2019

Wednesday, October 02, 2019

Thursday, October 03, 2019

Friday, October 04, 2019

Monday, October 07, 2019

Tuesday, October 08, 2019

Wednesday, October 09, 2019

<colgroup><col></colgroup><tbody>
</tbody>

 

[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