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


Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

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