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