[Steve]

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.

[Suzanne S. Barnhill]

See http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Steve" wrote in message
news
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.