I'm creating a mail merge using an Excel worksheet as the source file and the
letter is in Word. One of the items in the worksheet is a date field
formatted as HH:MM AM(PM). When the data is merged, it displays as HH:MM:SS
AM(PM). How can I get the merge to display in HH:MM AM(PM) format?