Concatenate with Date.

[chaju]

Hi, I have a problem here for showing Date in concatenate function.

Suppose in Cell A1 I have '25-Mar-02', Cell B2 I have 'Hello'.
by =CONCATENATE(A1,B1) will produce output 37341Hello.

Is there any way to display the 25-Mar-02Hello instead of the above mention.

Many thanks to those who help.
This message was edited by chaju on 2002-03-25 20:21
This message was edited by chaju on 2002-03-25 20:22

 

[BabyTiger]

Hi,

You might want to try the following:

=text(a1,"dd-mmm-yy")&b2