text and date format in a cell
 

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

text and date format in a cell
 

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

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556258

text and date format in a cell
 

Nic

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


Gord Dibben MS Excel MVP

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

text and date format in a cell
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=556258

text and date format in a cell
 

thank you all of you




daddylonglegs a écrit :

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=556258