day and time concatenate
 

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?

day and time concatenate
 

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

day and time concatenate
 

thanks, it works fine

"Bob Phillips" wrote:

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

day and time concatenate
 

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

day and time concatenate
 

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?

day and time concatenate
 

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?

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

day and time concatenate
 

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

What is in each of those cells?

--
Biff
Microsoft Excel MVP


"Warren Jo" wrote in message
...
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?

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

day and time concatenate
 

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

Regards,
Fred

"Warren Jo" wrote in message
...
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?

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