Convert 2 digit month to 4 digit years and months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
=TEXT(INT(A1/12)*100+MOD(A1,12),"0000")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
=TEXT(INT(A1/12)*100+MOD(A1,12),"0000")

--
HTH

Bob Phillips

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