Can I convert years to months in the amortization template?
 

I would like to have a full amortizatin table, but want to be able to use
months or partial years (i.e. 3.5 years or 42 months). Is there a way to
convert the amortization template? the only thing i can find is the auto
loan calculator, but that does not show the table.

Can I convert years to months in the amortization template?
 

There are only two corrections that need to be made. One is Data Validation
is set in some of the cells. Select cells and go to Data Menu - Validation
and change settings. Second the cell format is set to 0 decimal polaces.
Change format of cell to the number of places you require.

"Tatum" wrote:

I would like to have a full amortizatin table, but want to be able to use
months or partial years (i.e. 3.5 years or 42 months). Is there a way to
convert the amortization template? the only thing i can find is the auto
loan calculator, but that does not show the table.

Can I convert years to months in the amortization template?
 

That worked perfectly. Thanks for your help!

"Joel" wrote:

There are only two corrections that need to be made. One is Data Validation
is set in some of the cells. Select cells and go to Data Menu - Validation
and change settings. Second the cell format is set to 0 decimal polaces.
Change format of cell to the number of places you require.

"Tatum" wrote:

I would like to have a full amortizatin table, but want to be able to use
months or partial years (i.e. 3.5 years or 42 months). Is there a way to
convert the amortization template? the only thing i can find is the auto
loan calculator, but that does not show the table.