I have in:
A1 the date September 17,2012
B1 the Town.. Little Rock, AR
In C1, I did a concatenate, "+a1"&"at " &b1
and formated the cell for date with September, 17, 2012
but it gives me a date code(41165) plus the other concatenate data.
What I need is the date not the number.