day and time concatenate

[Guest]

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?

 

[Bob Phillips]

=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)

 

[Guest]

thanks, it works fine

=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)

 

[Dave Peterson]

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

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

 

[David Biddulph]

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.

 

[Warren Jo]

I can't make this work. This is my formula and I want E22 to be date
formatted:
=CONCATENATE(G22," ",C22," ",D22," ",E22)
Can you modify it for me?

 

[T. Valko]

=CONCATENATE(G22," ",C22," ",D22," ",E22)

What is in each of those cells?

 

[Fred Smith]

You probably want something like this:
=CONCATENATE(G22," ",C22," ",D22," ",Text(E22,"yyyy-mm-dd"))

Regards,
Fred