I am trying to concatenate a string and a date into one cell.
However when I do so the date convert to its numerical value.
I have them with a LF in a word wraped cell.

=INDIRECT("'"&$A10&"'!e24")&" days"&CHAR(10)&INDIRECT("'"&$A10&"'!
b24")

I want it to show
7 days
10/20/08

but it is showing
7 days
39741

Can this be done?