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

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?