How do I replace my vlookup FORMULA with just the TEXT of results

[Guest]

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?

 

[Guest]

=CONCATENATE($B$948,TEXT(S5,"mm/dd/yyyy"),$B$949,G5,$B$950,T5,$B$951,B5,$B$952)


The text function allows you to get the date format from S5. Adjust to suit