Truncating time format in Word merged document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TLC - 28 Nov 2007 02:14 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 28 Nov 2007 04:30 GMT

Press Alt + F9 to toggle the display the field codes and inside the
closing } add the following formatting switch:

\@ "hh:mm AM/PM"

Signature

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

> 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
[quoted text clipped - 4 lines]
> will
> be appreciated.

Reply to this Message

TLC - 28 Nov 2007 04:52 GMT

Thanks Doug. Works perfectly!

> Press Alt + F9 to toggle the display the field codes and inside the
> closing } add the following formatting switch:
[quoted text clipped - 9 lines]
> > will
> > be appreciated.

Reply to this Message