View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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