Thread: Trying to convert mm/yy in text to Dec-07, it adds day & current y
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excellency Excellency is offline
external usenet poster
  
Posts: 8
Default Trying to convert mm/yy in text to Dec-07, it adds day & current y
I have a cell that has mm/yy = 07/09 , I want it converted to display
Jul-2009 or Jul-09. But when I use DATEVALUE or format cell, it displays
09/07/2010 and does not let me display just MM:YY.
Thanks
Reply With QuoteReply With Quote