| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change number of years
How can I change the number of years on the Loan Amortization template? It
will only let me do 30 years and I need to do up to 40 years. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change number of years
I haven't checked if it still gives the correct answer (it should) but the
way to do it is select the years cell then data|validation change the upper value to 40 Mike "Cutter" wrote: How can I change the number of years on the Loan Amortization template? It will only let me do 30 years and I need to do up to 40 years. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change number of years
That cell has Data Validation which limits between 1 and 30.
Open the *.xlt file directly, not as a new workbook. Best way to do that is close Excel, browse to the folder the Template is stored in. Open the template from there. It will open as *.xlt Select and DataValidation. Change to 40 years and OK your way out. Save the Template. Gord Dibben MS Excel MVP On Sat, 28 Jul 2007 12:50:01 -0700, Cutter wrote: How can I change the number of years on the Loan Amortization template? It will only let me do 30 years and I need to do up to 40 years. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| years change to current year | Excel Worksheet Functions | |||
| Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) | |||
| how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
| How do I change months into years? | Excel Worksheet Functions | |||
Hybrid Mode
