View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
TLC TLC is offline
external usenet poster
 
Posts: 8
Default 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.