Unanswered: Stop Excel displaying seconds in Mail Merge
A question I hope will be nice and easy for you!
I am importing data from an inhouse data programe to Excel. One of the columns is a flight departure time. From this sheet I need to mail merge to a word document which extracts many of the fields including the departure time. However, the time always displays as hh:mm:ss. I only need to show hh:mm. I have tried changing in the format but in the formula bar is still shows hh:mm:ss which is what is being merged.
Please help!!! this will save us a lot of time in the office as we currently hand write everything! I'm not that savvy on jargon either so please kindly keep it simple for me!!
Howy, and welcome to the board. It may be that Excel is considering as text, not a (serial) number. One way to convert is to type the number 1 in a blank cell, copy it, then select the column with dates, and Paste Special > Multiply. This will convert them to true numbers, and then apply formatting as date as needed.
old, slow, and confused
but at least I'm inconsistent!