| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
