Improperly Displayed MergeField Format

[MaxArk]

I have a mail merge directory document which users data from an Exce
workshet as it's source. The datasource is volatile based on differen
criteria.

One of the fields is time. Sometimes, in the merged report, the time
are displayed as a decimal number. What is odd thought, the sam
report, with different data, will display the time properly. It is no
a repeated problem from one report to the next.

The Excel cells holding the data are formatted in time format. Th
merge field in the merge document is also formatted ... {MERGEFIEL
"Timedr5" \@ "h:mm AM/PM"}

Where should I be looking to find the source of this problem

 

[Doug Robbins - Word MVP]

How is the time entered in the data source. If it is in the format of h:m:s
or some variation thereof, that switch should work. Not however it will not
work for all times if the time is entered in the data source as h.m.s

Here is a probably explanation of why the latter format will not work that
was posted by Rich/rerat at the final post to the thread "Merging Time
Fields" that was posted by Kim on May 23:

I believe your data/values are being read like this:
08.30.00 = August 30, 2000 or just August 30 at midnight or 00:00:00 hrs
Because the "08" can represent the month of August
13.30.00 = 13:30:00
Since there is no 13th month, the "13" (or higher figure), will reflect the
24/military time correctly.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP