| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Truncating time format in Word merged document
This is probably a lame question.... I have a time in Excel (10:00:00 AM)
formatted in Excel to eliminate the seconds (10:00 AM), but when I merge the field into a Word merge doc, it displays as 10:00:00 AM. I want to eliminate the seconds from displaying in the merged Word document. Any guidance will be appreciated. |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Truncating time format in Word merged document
Press Alt + F9 to toggle the display the field codes and inside the
closing } add the following formatting switch: \@ "hh:mm AM/PM" -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "TLC" wrote in message ... This is probably a lame question.... I have a time in Excel (10:00:00 AM) formatted in Excel to eliminate the seconds (10:00 AM), but when I merge the field into a Word merge doc, it displays as 10:00:00 AM. I want to eliminate the seconds from displaying in the merged Word document. Any guidance will be appreciated. |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Truncating time format in Word merged document
Thanks Doug. Works perfectly!
"Doug Robbins - Word MVP" wrote: Press Alt + F9 to toggle the display the field codes and inside the closing } add the following formatting switch: \@ "hh:mm AM/PM" -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "TLC" wrote in message ... This is probably a lame question.... I have a time in Excel (10:00:00 AM) formatted in Excel to eliminate the seconds (10:00 AM), but when I merge the field into a Word merge doc, it displays as 10:00:00 AM. I want to eliminate the seconds from displaying in the merged Word document. Any guidance will be appreciated. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format outlook address block not part of merged document | Microsoft Word Help | |||
| how to keep date format in merged document same as in data source | Microsoft Word Help | |||
| Format Date and Time to show Military Time | Microsoft Word Help | |||
| How do I format date and time fields in a merge document? | Mailmerge | |||
| Word 2003 Merged Dates show time after date | Microsoft Word Help | |||
Linear Mode
