Convert Number into Month and Year

Dear Friends,

I have a column in which the numbers are entered like:

1112
1112
1212
1212
1212
0113
0113
0113

I want to convert the above data as (MMM-YYYY format):

1112 - as Nov-2012
1212 - as Dec-2012
0113 - as Jan-2013

Is it possible? Kindly help me.

Perhaps

Please Login or Register  to view this content.

and format as needed

If your numbers start in A1, try this in B1. Format the result as Custom: mmm-yyyy

=DATE(RIGHT(A1,2)+100,LEFT(A1,2),1)

- Moo

Dear Friends,

Excellent reply and thanks for your swift response.

After applying the formula it works exactly. However, it considers the first day of the related month.
But, how to get the last of that month? is there any solution?

maybe..

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Thanks to all for immediate solution.