Remove seconds from 'time' field in Excel/Word merge document?

R

Rosemary Spencer

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.
 
P

Peter Jamieson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format change in merge data - Bold formatting after a comma 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Merge Excel file into Word Document 3
Embedded Excel into Word with Tables 0
Always getting a log in dialog. 0
Truncating time format in Word merged document 2
Indenting every other paragraph in Word at the same time? 0
Integrating information from Word to Excel (not mail merge) 1

Top