Can I convert years to months in the amortization template?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
That worked perfectly. Thanks for your help!

Joel said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create amortization schedule 0
loan amortization template 3
Date function within loan amortization spreadsheets 3
loan amortization template 2
loan amortization years 4
Amortization Schedule 11
is there any way to create a formula in excel for amortizing 2
loan amortization schedule - skiped months 2

Back
Top