Excel Date and Time Function
I have a column of dates formatted as m/d/yyyy and another column of
times formatted as hh:mm:ss. I would like to merge them into one column. When I concatenate to do this the format of the date changes to a serial number and I can't get it to be formatted in m/d/yyyy. |
Excel Date and Time Function
Hi
Don't concatenate, just ad the cells =A1+B1 -- Regards Roger Govier wrote in message s.com... I have a column of dates formatted as m/d/yyyy and another column of times formatted as hh:mm:ss. I would like to merge them into one column. When I concatenate to do this the format of the date changes to a serial number and I can't get it to be formatted in m/d/yyyy. |
Excel Date and Time Function
And format the result cell as d/m/yyyy hh:mm:ss, or whatever you're looking
for. -- David Biddulph "Roger Govier" wrote in message ... Hi Don't concatenate, just ad the cells =A1+B1 wrote in message s.com... I have a column of dates formatted as m/d/yyyy and another column of times formatted as hh:mm:ss. I would like to merge them into one column. When I concatenate to do this the format of the date changes to a serial number and I can't get it to be formatted in m/d/yyyy. |
All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com