Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using Excel 2003 and trying to get the existing template for a loan that
will be amortized over 40 years. Excel will not let me enter a number above 30. How do I circumvent this problem? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select that cell(D8) and DataValidation.
Remove or change the validation rule that limits you to 30 years. You will also have to edit any of the range names that refer to row 378 Add 120 to those..................498 Then copy the formulas from row 378 down to row 498 Nothing to it<g Gord Dibben MS Excel MVP On Wed, 18 Mar 2009 10:24:31 -0700, Roy wrote: I am using Excel 2003 and trying to get the existing template for a loan that will be amortized over 40 years. Excel will not let me enter a number above 30. How do I circumvent this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Loan Amortization Schedule | Excel Worksheet Functions | |||
Loan amortization schedule should have subtotals for each year | Excel Worksheet Functions | |||
Loan Amortization Schedule | Excel Worksheet Functions | |||
loan amortization schedule | Excel Discussion (Misc queries) | |||
Loan amortization schedule | New Users to Excel |