Hector

I used your recommendation this the output. It displays current year on
instead of 2009, 2007 or 2006

10/09 = Oct - 10
08/07 = Aug-10
11/06 = Nov-10

thanks
Keddy

"Héctor Miguel" wrote:

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.


.