Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Improperly Displayed MergeField Format
I have a mail merge directory document which users data from an Excel workshet as it's source. The datasource is volatile based on different criteria. One of the fields is time. Sometimes, in the merged report, the times are displayed as a decimal number. What is odd thought, the same report, with different data, will display the time properly. It is not a repeated problem from one report to the next. The Excel cells holding the data are formatted in time format. The merge field in the merge document is also formatted ... {MERGEFIELD "Timedr5" \@ "h:mm AM/PM"} Where should I be looking to find the source of this problem? -- MaxArk |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Improperly Displayed MergeField Format
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 "MaxArk" wrote in message ... I have a mail merge directory document which users data from an Excel workshet as it's source. The datasource is volatile based on different criteria. One of the fields is time. Sometimes, in the merged report, the times are displayed as a decimal number. What is odd thought, the same report, with different data, will display the time properly. It is not a repeated problem from one report to the next. The Excel cells holding the data are formatted in time format. The merge field in the merge document is also formatted ... {MERGEFIELD "Timedr5" \@ "h:mm AM/PM"} Where should I be looking to find the source of this problem? -- MaxArk |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge data displays improperly | Mailmerge | |||
mergefield time format switch ignored | Mailmerge | |||
Format Mergefield Decimal Values | Microsoft Word Help | |||
Format true/false mergefield | Mailmerge | |||
Mergefield format | Mailmerge |