Hi

Then try
FormatCellsNumberCustom h:mm AM/PM


--
Regards

Roger Govier


"Tara" wrote in message
...
Thank you but in doing so it converts the time to a 24 hour clock and
I need
it to remain 12 hour (2:00 PM vs 14:00)

Tara

"Roger Govier" wrote:

Hi Tara

FormatCellsNumberCustom h:mm

--
Regards

Roger Govier


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