Custom format the cell as yyyy-mm-dd hh:mm (or adjust to suit).
But in my book, 19322 is 1952-11-24 00:00, not 2007-02-15 00:00. The latter
would be 39128.
--
David Biddulph

"P Boric" wrote in message
...
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?