A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I format a merge field to display the correct Time format



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2010, 07:27 PM posted to microsoft.public.word.mailmerge.fields
KHaberwoman
external usenet poster
 
Posts: 7
Default How do I format a merge field to display the correct Time format

OS: XP
Program: Office 2007
I have a merge document word/excel but in my excel sheet the cells are
formatted to display the time as 00:00 AM but when I merge the document in
Word, the time displays as 00:00:00 AM.

How can I fix this?

  #2  
Old March 19th, 2010, 08:12 PM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default How do I format a merge field to display the correct Time format

Hi KHaberwoman,

To get the time format you want, you can add a formatting picture switch. In Word:
.. select the mergefield;
.. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyTime} where 'MyTime' is your mergefield's
name;
.. delete anything appearing after the mergefield's name and add '\@ "h:mm"' or '\@ "h:mm am/pm"', as in {MERGEFIELD MyTime \@ "h:mm
am/pm"}. Note: you must use lowercase 'm's for minutes;
.. if you want the hours and/or minutes to display leading 0s, change 'h' to 'hh for hours and 'm' to 'mm' for minutes;
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.


--
Cheers
macropod
[Microsoft MVP - Word]


"KHaberwoman" wrote in message ...
OS: XP
Program: Office 2007
I have a merge document word/excel but in my excel sheet the cells are
formatted to display the time as 00:00 AM but when I merge the document in
Word, the time displays as 00:00:00 AM.

How can I fix this?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.