One way:

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

In article ,
"kevin" wrote:

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?