View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dawn Crosier, Word MVP Dawn Crosier, Word MVP is offline
external usenet poster
 
Posts: 425
Default Time format in Mail Merge field

Insert it after the second quote mark in your field, and before the
closing French brace.

See also http://word.mvps.org/FAQs/MailMerge/index.htm for further
clarification

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.




"Look2TheSky2" wrote in message
:

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.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date: 9/26/2007 12:12 PM


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date:
9/26/2007 12:12 PM