Date reverts to numeric format

[ManhattanRebel]

I have a date in this format May 1, 2009. I’d like to keep it in that format,
but when I concaternate it with another cell, the date converts to a numeric
format. How can I prevent this?

 

[Jacob Skaria]

Try the below
=TEXT(A1,"mmm d, yyyy")

=TEXT(A1,"mmm d, yyyy") & A2

If this post helps click Yes

 

[David Biddulph]

=TEXT(A1,"mmm d, yyyy")&" the text to which you want it concatenated"
or
=TEXT(A1,"mmmm d, yyyy")&" the text to which you want it concatenated"

 

[ManhattanRebel]

Thank you... I appreciate your help.

=TEXT(A1,"mmm d, yyyy")&" the text to which you want it concatenated"
or
=TEXT(A1,"mmmm d, yyyy")&" the text to which you want it concatenated"
--
David Biddulph





.