In an adjacent column, use

=DATEVALUE(A1)

and format as mmm-yyyy

--
__________________________________
HTH

Bob

"John" wrote in message
...
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