Convert 2 digit month to 4 digit years and months
 

How can i convert a 2 digit number of months to a four digit showing years
and months?


35 = 0211
24 = 0200
05 = 0005

I have a series of numbers containg months, like 35. I want it to come out
to years and months 0211. 35 months is 2 years and 11 months. I want it to
show 0211.

Thanks,

Convert 2 digit month to 4 digit years and months
 

=TEXT(INT(A1/12)*100+MOD(A1,12),"0000")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"BB" wrote in message
...
How can i convert a 2 digit number of months to a four digit showing years
and months?


35 = 0211
24 = 0200
05 = 0005

I have a series of numbers containg months, like 35. I want it to come
out
to years and months 0211. 35 months is 2 years and 11 months. I want it
to
show 0211.

Thanks,

Convert 2 digit month to 4 digit years and months
 

=TEXT(INT(A1/12),"00")&TEXT(MOD(A1/12,1)*12,"00")


"BB" wrote:

How can i convert a 2 digit number of months to a four digit showing years
and months?


35 = 0211
24 = 0200
05 = 0005

I have a series of numbers containg months, like 35. I want it to come out
to years and months 0211. 35 months is 2 years and 11 months. I want it to
show 0211.

Thanks,