Concatening a text and a date

[c991257]

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: ", DAY(A1),"/",MONTH(A1),"/",YEAR(A1))

But that gives me
This date: 3/5/2006

I would prefer if the day was two digit and the month 3-letters.

Anyone?

/Møller

[Bearacade]

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

[Alan]

Try with the date in A1,
="This Date: "&TEXT(A1,"dd-mmm-yy")
Regards,
Alan.
"c991257" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[c991257]

Thanks

/Møller