How do you keep a date formatted as a date when using the concatenate function in excel

I am using the concatenate function in excel with one of the columns being a date in the month/day/year format.  When it is concatenated it always shows up as  hexadecimal number.   Is there a way to keep the date format?
Who is Participating?
dsackerConnect With a Mentor Contract ERP Admin/ConsultantCommented:
If A2 is some code, B2 is a date, and you want to concatenate in C2, you would enter the following in C2:

=A2 & " " & TEXT(B2, "mm/dd/yyyy")

You can play with the TEXT format codes, if you want something different.
try converting date cells to text, to avoid getting unwanted output results.
Harry LeeCommented:
I would say dsacker's solution is the best. It does not involve any function in the formula.

His solution =A2 & " " & TEXT(B2, "mm/dd/yyyy")

Is pretty much the same as =CONCATENATE(A2," ",TEXT(B2,"mm/dd/yyyy"))

But runs a micro little bit faster.

It's ironic that Microsoft bother putting the Concatenate function in Excel since the "&" can pretty much do the same thing slightly faster.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.