Date concatenate?

[Hilton]

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

 

[JE McGimpsey]

One way:

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

 

[Hilton]

Works, than you!

One way:

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