Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Remove seconds from 'time' field in Excel/Word merge document?
545 views
Skip to first unread message
Spencer@discussions.microsoft.com Rosemary Spencer
Sep 30, 2008, 10:49:00 AM9/30/08
to
In Office 2003 SP3, my Word memo includes a 'time' field merged with an Excel
data source and I'm trying to find a way of removing the seconds that appear
in the Word document field, ie 10:00:00. The Excel 'time' is displayed as
10:00.
data source and I'm trying to find a way of removing the seconds that appear
in the Word document field, ie 10:00:00. The Excel 'time' is displayed as
10:00.
Peter Jamieson
Sep 30, 2008, 2:44:16 PM9/30/08
to
In word, press Alt-F9 to reveal the underlying field code, e.g.
{ MERGEFIELD mytimefield }
and type a "date/time formatting switch" so it looks like the following:
{ MERGEFIELD mytimefield \@hh:mm }
If you see \*Mergeformat, delete it
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Rosemary Spencer" <Rosemary Spe...@discussions.microsoft.com> wrote in
message news:2059D4AF-BEE5-4E08...@microsoft.com...
0 new messages