Extract Month numbers from years and remove zero as well

[hananak]

Dear All,

I have Years with Month numbers in one column. I am trying to extract months from the them but want to remove zero as well. For example. This is the result I want.

202201 = 1
202202 = 2
202203 = 3
202204 = 4
202205 = 5
202206 = 6
202207 = 7
202208 = 8
202209 = 9
202210 = 10
202211 = 11
202212 = 12

When I use right formula to extract 2 digits - I get 01 instead of 1. How to remove this 0? This mentioned below is my current result.

202201 = 01
202202 = 02
202203 = 03
202204 = 04
202205 = 05
202206 = 06
202207 = 07
202208 = 08
202209 = 09
202210 = 10
202211 = 11
202212 = 12

Your help would be really appreciated.

 

[Rick Rothstein]

Just add zero to your formula and that will convert them into real numbers...

=0+RIGHT(A1,2)

 

[hananak]

Just add zero to your formula and that will convert them into real numbers...

=0+RIGHT(A1,2)

Thank you very much for your help and for quick response.

It is working now.

Cheers