Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
Special Cell Format | Excel Discussion (Misc queries) | |||
Format Paste Special - is there a way to do this ? | New Users to Excel | |||
excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
excel data label format special number characters | Excel Discussion (Misc queries) |