Truncating time format in Word merged document
Thanks Doug. Works perfectly!
"Doug Robbins - Word MVP" wrote:
Press Alt + F9 to toggle the display the field codes and inside the
closing } add the following formatting switch:
\@ "hh:mm AM/PM"
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"TLC" wrote in message
...
This is probably a lame question.... I have a time in Excel (10:00:00 AM)
formatted in Excel to eliminate the seconds (10:00 AM), but when I merge
the
field into a Word merge doc, it displays as 10:00:00 AM. I want to
eliminate
the seconds from displaying in the merged Word document. Any guidance
will
be appreciated.
|