Converting months to years

[kevin]

Hi, I used the nper function and the result is x months, what formula can i
use to convert that to x years, y months. simply dividing by 12 will give me
11.5 ie 11 and a half years. I want the answer to be 11 years, 6 months. any
ideas?

 

[JE McGimpsey]

One way:

=INT(A1/12) & " years, " & MOD(A1,12) & " months"