One way:

=TEXT(A1,"dd/mm/yyyy - ") & TEXT(B1,"dd/mm/yyyy")


In article ,
"Hilton" wrote:

How do I concatenate two cells - one with a start date and the other with an
end date without Excel changing it to date values?

i.e I want to end up with 01/01/2006 - 31/12/2006 not 38718-39082