unable to change the format of time shown in mail merge
Thank you so much. That was very helpful.
"macropod" wrote:
Hi Kim,
You can do this by adding a picture switch to your mergefield.
To do this:
.. select the mergefield and press Shift-F9 to expose the field coding. It
should look something like
{MERGEFIELD MyTime}
where 'MyTime' is your mergefield's name.
.. delete anything currently appearing after your mergefield's name and add
'\@ "h:m am/pm"', so that your field looks like:
{MERGEFIELD MyTime \@ "h:m am/pm"}.
.. if you want the hours and minutes to display leading 0s, change 'h:m' to
'hh:mm'.
.. press F9 to update the field.
.. run your mailmerge.
Cheers
--
macropod
[MVP - Microsoft Word]
"Kim B." Kim wrote in message
...
I have an excel data table that contains various information for travel
that
I have planned for other individuals. In excel any fields I have shown
with
time are shown for example as 1:15 PM but when this data gets merged into
my
word document is shows as 1:15:00 PM. How can I eliminate the seconds?
|