Nic

=A1 & TEXT(A2,"ddmmyy" & A3)


Gord Dibben MS Excel MVP

On 27 Jun 2006 15:09:32 -0700, "Nicawette" <nicolasdestree@yahoo.fr> wrote:

>Hi all,
>
>is it possible to format an excel cell with a text and a date in the
>same cell ?
>
>eg :
>
>In A1 I've a text cell : "360 :"
>In A2 I've a date formated in ddmmyy
>In A3 I've a text cell :"zzzzzzz"
>
>In A4 I would like to concatenate all the cells but I've the following
>result : "360:38895zzzzzzz" instead of "360:ddmmyyzzzzzzz" where 38895
>is the excel date.
>
>Thank you
>
>Nic