I would like to input a time without the seconds showing
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. |
I would like to input a time without the seconds showing
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. |
I would like to input a time without the seconds showing
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. |
I would like to input a time without the seconds showing
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. |
I would like to input a time without the seconds showing
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 merge and don't want the time to reflect seconds. |
Quote:
|
All times are GMT +1. The time now is 12:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com