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.