I am using the Concatenate function to generate a paragraph (i.e.
=CONCATENATE($B$948,S5,$B$949,G5,$B$950,T5,$B$951, B5,$B$952)). The values
in column S are the result of a Vlookup and formatted as "Date"

As such, when I put them in the paragraph of concatenated text I get a
5-digit value that has nothing to do with the date that results in S from the
V Lookup (E.g. 4/11/05 reads "38453" ... but when I replace the Vlookup
function with "April 11, 2005" the value concatenates perfectly.)

How do I tell Excel that I want it to replace the Vlookup formula with the
value that resulted from said Vlookup?