Patricia wrote:
I am trying to merge multiple text cells and a date cell ...
So far, it won't let the data in the date cell show as a date, only as number.

Help!!


You need the TEXT() worksheet function.

Something like this...

=H3&" "&TEXT(G3,"dddd, mmmm dd, yyyy")&" "&H4