I have exported data from Access into excel. I am trying to mail merge the
data into Word. One piece of data is the Date_of_Debt (which is a date).

My data connection works using Date_of_Debt. But when I look at the merged
data in word the date is showing as follows: 2005-08-02 00:00:00. No matter
how I format the date in excel (including using text format, general, and
different date formats) it still appears the same. I have also tried to
format the field in Word without success. Does anybody have any ideas?

Thx for the help in advance.

Steve

Qutie a bit of info at this site on keeping formats when mail merging to Word
from Excel.

http://office.microsoft.com/en-ca/as...164951033.aspx


Gord Dibben MS Excel MVP

On Tue, 24 Oct 2006 13:50:02 -0700, Steve
wrote:

I have exported data from Access into excel. I am trying to mail merge the
data into Word. One piece of data is the Date_of_Debt (which is a date).

My data connection works using Date_of_Debt. But when I look at the merged
data in word the date is showing as follows: 2005-08-02 00:00:00. No matter
how I format the date in excel (including using text format, general, and
different date formats) it still appears the same. I have also tried to
format the field in Word without success. Does anybody have any ideas?

Thx for the help in advance.