If you're talking not about how the cells are displayed in Excel, but how
the data appears in a mail merge in Word, try
http://office.microsoft.com/en-us/wo...164951033.aspx
The easy option is to produce a helper column using the TEXT() function.
--
David Biddulph
"Tara" wrote in message
...
I have tried to format the cell by using both general and time formats.
When
using h:mm AM/PM the seconds till show up. I am using this for a mail
merge
and don't want the time to reflect seconds.