Thread: Convert Date in Text to month and Year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excellency Excellency is offline
external usenet poster
  
Posts: 8
Default Convert Date in Text to month and Year
I am trying to convert text to month and year. In the cell it displays as
07/09 i want it show Jul-2009 or 2009-Jul. When i use DATEVALUE or DATE it
adds current year and displays something like 02/15/2010. Any idea what i am
doing wrong..

thanks
Reply With QuoteReply With Quote