Convert 2 digit month to 4 digit years and months

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,
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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

Bob Phillips

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

--
HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change a list of 2 digit years to 4 digit years? 5
Excel 1 vs 10 in Excel Formula 0
Excel Formula for years and months 2
Add/Sum up months, years, dates 4
Summation of months or years 6
problem with days months and years conversion 1
2 digit years being converted incorrectly 1
compounding years and months 1

Top