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