Error when combinining two dates in one column

[mark05221986]

Hi,

I’m trying to combine 2 datas from different cell. One cell has "18/01/2014" and "27/01/2014" in onother cell. I want the result in another cell to be "18/01/2014 to 27/01/2014". When I try the concatenate formula, I get "41657 to 41666" as a result. Please help me. Thank you.

Mark

 

[Useful]

Hello!
use =text(A1,"dd.mm.yyyy")&" to "&text(A2,"dd.mm.yyyy")

 

[mark05221986]

Thanks.