LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loans aren't always an even number of years Mike Davis Excel Discussion (Misc queries) 1 February 20th 06 08:30 PM
Change Xcel Amortization from 30 years to 40 years? onroad80 Excel Discussion (Misc queries) 1 November 28th 05 11:36 PM
Loan amortization schedule AMS228 New Users to Excel 0 April 30th 05 02:56 AM
Variable rate loan amortization template ColoAvsPuckhead Excel Discussion (Misc queries) 0 April 7th 05 05:29 PM
The number change from 1350 to 13.5 and Enter does not function properly hon123456 Excel Discussion (Misc queries) 2 January 19th 05 02:41 PM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"