View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rosemary Spencer Rosemary Spencer is offline
external usenet poster
 
Posts: 1
Default Remove seconds from 'time' field in Excel/Word merge document?

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.