9-2008 being in B1
=DATE(RIGHT(B1,4),LEFT(B1,SEARCH("-",B1)-1),1)
and custom format the result cell like mmm-yyyy

Regards,
Stefi

€žJohn€� ezt Ã*rta:

Does anyone know the formula which will convert numbers into months for
example:

9-2008 and I need Sep-2008 have tried changing the column into a Custom type
using mmm-yy but it completely changes the month and year. The data has been
taken from our company operation system which is SAP.

Thanks