Thread: Date reverts to numeric format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Date reverts to numeric format
Try the below
=TEXT(A1,"mmm d, yyyy")

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

If this post helps click Yes
---------------
Jacob Skaria


"ManhattanRebel" wrote:

I have a date in this format May 1, 2009. Id 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?
Reply With QuoteReply With Quote