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.

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.

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.