Thread: Trying to convert mm/yy in text to Dec-07, it adds day & current y
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Héctor Miguel Héctor Miguel is offline
external usenet poster
  
Posts: 434
Default Trying to convert mm/yy in text to Dec-07, it adds day & current y
hi, !

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.

try: =text(datevalue(a1),"mmm-yy")

or (for international issues): =text(datevalue(a1),"mmm-")&year(datevalue(a1))

hth,
hector.


Reply With QuoteReply With Quote