If Bob's worked ok, then this should, too:

=text(a1+b1, "yyyy-mm-dd hh:mm:ss")

P Boric wrote:

I have days stored in a column, and dates associated to them in other. Whe I
try to concatenate them in a single cell, the numbers are converted and I get
something like this:

day time concatenate
2007- 02-15 0.00 19322

I've tried formatting in different ways the cells involved, without success
Any suggestion?

--

Dave Peterson