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