I can't get the proper date to show up in word after a mail merge. I know there are lots of post on this already but it does not solve my problem.



No matter what format the date is in for excel it comes out as a 5 digit number in word. Other words it changes the date to General.

If I enter the following date: 14 Apr 13

The following appears in word: 41378

How can I change that to the actual date?

The mergefield looks as follows

{MERGFIELD title of column}

It doesn't say date so I can't change it there.