Jump to content

Recommended Posts

Posted

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.

Jennifer


Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...