Hi Thank you both. That works perfectly.

"manfareed" wrote:

Hi ,

I need to extract November as "11" from November 2007. But this can change
depending on the current month eg. "12" from December 2007.

"11" should be in number format so that it can be used in calculations to
calculate average costs.

Thanks,