View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
andreaw
 
Posts: n/a
Default loan amortization- how can I enter 4.75 years? no a whole number

I am using the loan amortization template available for excel. The loan I am
using is for 4.75 years (4 years 9 months). The template will not allow me
to use 4.75 years, it will only accept whole numbers between 1 and 30. Does
anyone have any suggestions on how I can get around this? Thank you!