Please help.

I want to convert a date serial number into a long date text string so that
I caan incorporate in a concanenated statement. Whenever I use a cell wher i
think I have done this the value that appears in the concat statement is the
original serial number

Thanks