View Single Post
 
Old 03-01-2013, 07:58 AM
Jeff68 Jeff68 is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Mar 2013
Posts: 4
Jeff68 is on a distinguished road
Question Mail merge dates

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.
Reply With Quote