On Wednesday, April 29, 2015 at 4:11:16 PM UTC+5:30, Claus Busch wrote:
Hi again,

Am Wed, 29 Apr 2015 12:35:47 +0200 schrieb Claus Busch:

In B2 use =TEXT(A2,"MMM")&"-"&TEXT(A2,"JJ")

sorry, that is the german format
Try:
=TEXT(A2,"MMM")&"-"&TEXT(A2,"YY")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Thanks Claus.. That worked

San