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
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