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

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

Works, than you!

"JE McGimpsey" wrote in message
...
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