Concatening a text and a date
 

Hi

I'm having trouble concatenating a text string with a date:

I cell a1 I have the date 03-may-06

In a different cell I have the function:
=CONCATENATE(" This date: ",a1)

which returns:

This date: 38840.

I can't seem to find a function that converts the serial back to the
date format that I entered.

I could use =CONCATENATE("This date: ",
DATE(YEAR(A1),MONTH(A1),DAY(A1)))

But that gives me
This date: 03/05/2006

Anyone?

/Møller


--
c991257
------------------------------------------------------------------------
c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=563008

Concatening a text and a date
 

=CONCATENATE(" This date: ",TEXT(A1,"dd-mmm-yy"))


--
Bearacade


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

Concatening a text and a date
 

Try with the date in A1,
="This Date: "&TEXT(A1,"dd-mmm-yy")
Regards,
Alan.
"c991257" wrote in
message ...

Hi

I'm having trouble concatenating a text string with a date:

I cell a1 I have the date 03-may-06

In a different cell I have the function:
=CONCATENATE(" This date: ",a1)

which returns:

This date: 38840.

I can't seem to find a function that converts the serial back to the
date format that I entered.

I could use =CONCATENATE("This date: ",
DATE(YEAR(A1),MONTH(A1),DAY(A1)))

But that gives me
This date: 03/05/2006

Anyone?

/Møller


--
c991257
------------------------------------------------------------------------
c991257's Profile:
http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=563008

Concatening a text and a date
 

Thanks

/Møller


--
c991257
------------------------------------------------------------------------
c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=563008