Concatenate 2 dates

[Riaang]

Hi, I have a date in column A and a date in column B. I want to concatenate the 2 dates to form a text string eg.

Column A Column B Column C
26 May 2010 28 May 2010 26 May 2010 to 28 May 2010

I use the following formula in column C to create the text string

=A2&" to "&B2

The problem is I get the following result in column C

40324 to 40324

and I need help to get the following result

26 May 2010 to 28 May 2010

Thanks

 

[VoG]

Try

=TEXT(A2,"dd mmmm yyyy")&" to "&TEXT(B2,"dd mmmm yyyy")

 

[Riaang]

Thanks a lot, I knew it was something simple.