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