SPECIAL NUMBER FORMAT

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

Faraz A. Qureshi

I have come upto the custom format:

# "Years and " ?/12 "Months"

so as to represent

33.43189596
as
33 Years and 5/12 Months

However, any idea for modification of the same thus enabling me to reflect
the same without "/12" i.e. like:

33 Years and 5 Months
 
with your value in A1, try:

=ROUNDDOWN(A1,0) &" years "& ROUNDDOWN(MOD(A1,1)*12,0) & " months"
 
Not sure if you can do all that with just a number format, but would a helper
column with a formula work?

=INT(A1)&" years and "&INT(MOD(A1,1)*12)&" months"
 
Back
Top