=TEXT(A1,"yyyy-mm-dd")&" "&TEXT(B1,"hh:mm")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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?