Joerg

Excel has a standard function for this.

="The date is " & TEXT(A1,"mmmm d" &"," &"yyyy")


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 11:48:12 +0900, "Joerg" wrote:

It seems that this is not possible with standard function, but you can build
a custom function, e.g.

Function DisplayedText(CellAddress As Object)
DisplayedText = CellAddress.Text
End Function

The cell holding the concatenated text would look like
="The date is " & DisplayedText(A1)

It would concatenate whatever is displayed in A1, i.e the formatted date and
not the serial number.

Nevertheless I understand if you would prefer using a standard function. I
don't know why it's not there.

Joerg



"JGG" wrote in message
.. .
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