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