text and date format in a cell

[Nicawette]

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

[Bearacade]

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

HTH

[daddylonglegs]

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

[Gord Dibben]

Nic

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


Gord Dibben MS Excel MVP

On 27 Jun 2006 15:09:32 -0700, "Nicawette" <[email protected]> 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

[Nicawette]

thank you all of you




daddylonglegs a =E9crit :

> =3DA1&TEXT(A2,"ddmmyy")&A3
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php?action=3Dge=
tinfo&userid=3D30486
> View this thread: http://www.excelforum.com/showthread...hreadid=3D556=
258