mail merge change the format of the date

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,565
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>
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,099,461
Messages
5,468,781
Members
406,608
Latest member
G3TEN

This Week's Hot Topics

Top