View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ManhattanRebel ManhattanRebel is offline
external usenet poster
 
Posts: 85
Default Date reverts to numeric format

Thank you... I appreciate your help.

"David Biddulph" wrote:

=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


"ManhattanRebel" wrote in message
...
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?



.