WaterlooCOW Posted September 26, 2007 Posted September 26, 2007 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now