SPECIAL NUMBER FORMAT
with your value in A1, try:
=ROUNDDOWN(A1,0) &" years "& ROUNDDOWN(MOD(A1,1)*12,0) & " months"
--
Gary''s Student - gsnu201001
"Faraz A. Qureshi" wrote:
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
--
Thanx in advance,
Best Regards,
Faraz
|