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.
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.