=a1&b2&" this is more text " & text(b99,"mm/dd/yyyy")



Hi_no_Tori wrote:

When I concatenate a text and a date in Excel, the date is converted
automatically to a number... Is there anything I can do in order to
concatenate a text and a date without losing the original formatting of the
date?

--

Dave Peterson