Convert date number to date when Concatenating

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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!