Serial Numbers converted to text string
 

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

Serial Numbers converted to text string
 

Suppose the serial number is in A2, then use in concatenation

=TEXT(A2,"dd.mm.yyyy")

or use any other suitable date format!

Regards,
Stefi



€žJGG€� ezt Ã*rta:

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

Serial Numbers converted to text string
 

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

Serial Numbers converted to text string
 

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