| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number of days into years/months | Excel Discussion (Misc queries) | |||
| How to convert a number to years, months, days? | Excel Worksheet Functions | |||
| convert # of years, months and days | Excel Discussion (Misc queries) | |||
| Change years to months in loan amortization template | Excel Worksheet Functions | |||
| How do i convert years to months (formula) | Excel Worksheet Functions | |||
Hybrid Mode
