Mail merge times; How not to show seconds please?

  • Thread starter Thread starter gill.webster
  • Start date Start date
G

gill.webster

I have a spreadsheet being used for mail-merge to Word letters, which
includes times for appointments. In the s'sheet the formatting is for
hh:mm but on merging the seconds also show and this is not required.

I'd like to know the easiest way of merging to show only the hour &
minutes. Is there a formula to convert or remove the seconds values
please?

I'd rather not have to manually enter another column of "text"
formatted times if there is another way that anyone can help me with
please?

Thanks a lot.
 
Hi Gill,
I see you expected an answer within an hour. Please allow 48 hours.

Personally being oriented to Excel, I would stick to formating
as text in Excel. You could copy the worksheet with a macro
and convert all cells to their text components and then use that
sheet, and your new sheet would have to be the first sheet in
the workbook -- minor change
Sheets(ActiveSheet.Name).Copy Before:=Sheets(1)
to the macro at:
Proper, and other Text changes -- Use of Special Cells
"Convert all cells to text values (#Text)"
http://www.mvps.org/dmcritchie/excel/proper.htm#text
You might also color the entire spreadsheet to a light gray
so you know it is only a copy for use with MailMerge and/or
rename the worksheet accordingly.

But more in accordance with your request, you can enter the
formatting in your Word document.

Mail Merge FAQ (Cindy Meister)
"Force Word to use the number format you want"
http://homepage.swissonline.ch/cindymeister/mergfaq.htm
 
Back
Top