day and time concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
=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)
 
thanks, it works fine

Bob Phillips said:
=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)
Click to expand...
 
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.
 
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?
 
You probably want something like this:
=CONCATENATE(G22," ",C22," ",D22," ",Text(E22,"yyyy-mm-dd"))

Regards,
Fred
 
Back
Top