I had read about the possibility of using DDE, and will try it, but I was
concerned about possible unintended side effects since I am designing this
for use by other people in my group, and I would (I assume) have to make this
change to Word option settings on each PC where someone might need to use
this document. What other effects might this change have? I don't know of any
other mailmerge documents being used but I'm not familiar with every document
used within my group.

"Graham Mayor" wrote:

I have tried, but can't reproduce this. If you enter a time in Excel as
00:05 then Excel gives this a custom format of hh:mm. The underlying data in
Excel (see the command line) is 00:05:00. If you format the cells as TIME
then depending on which format you select the time could be shown as
00:05:00 AM.

You could get the results you report if the times in Excel are formatted as
dates, but I would have thought that would have been obvious.

If you are sure that your times are correctloy formatted then use the
alternative connection method to attach your data file - see the Excel data
section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Pauline Evans wrote:
I am doing a merge from Excel 2003 to Word 2003, and the field is
formatted as time in Excel (just time, no date). In Word I am trying
to use a format switch to format the time since I read that Word just
gets the raw data from Excel. My field is written as { mergefield
Time \@ "HH:mm" }, which for a value in Excel of 0:05 should give me
00:05 but instead gives me 12/30/1899 12:05:00 AM. I have tried
adding or taking away spaces, single vs. double quotes or no quotes,
varying time formats, and the result is always the same. I have
searched forums for an answer and have seen other people with the
same question but have not yet seen an answer beyond what I have
already tried.