Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
I am merging data from an Excel worksheet into a Word document. Although the
time data in Excel is formatted as h:mm AM/PM, the same time presented in the merged document appears as h:mm:ss AM/PM. I think I need to use a switch in the merged field to reformat it to the preferred h:mm AM/PM. On the merge document, the field looks like this (after alt-f9) .... {MERGEFIELD "Start_Time"}. I do not know how or where to insert the switch (\@ "h:mm AM/PM)?? Thanks in advance for your help. A simple problem, but one I am struggling with. |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
unable to change the format of time shown in mail merge | Mailmerge | |||
Display time in correct format in a mail merge | Mailmerge | |||
can I change time field settings to 24hr clock format in mail merg | Mailmerge | |||
Word 2002 mail merge needs to show time in hh:mm format | Mailmerge | |||
how do i delete "time" from date/time merge field in mail merge? | Mailmerge |