Serial Numbers converted to text string

[JGG]

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

 

[Stefi]

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:

 

[Joerg]

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

 

[Gord Dibben]

Joerg

Excel has a standard function for this.

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


Gord Dibben MS Excel MVP