Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the loan period in a amortization from years to mo
I would like to change the loan period in an amortization schedule from year
to months. Any sugestions on how to do this in a template that was downloaded? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the loan period in a amortization from years to mo
Checkout this:
http://www.vertex42.com/ExcelTemplat...-schedule.html it is pretty flexible -- Gary''s Student - gsnu200779 "Paigem21" wrote: I would like to change the loan period in an amortization schedule from year to months. Any sugestions on how to do this in a template that was downloaded? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the loan period in a amortization from years to mo
I did that. I need to put in 65 months for the Loan_Years but it says years
only. I need it to calculate months instead of years. Can you help me? "Paigem21" wrote: I would like to change the loan period in an amortization schedule from year to months. Any sugestions on how to do this in a template that was downloaded? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the loan period in a amortization from years to mo
65 months is 5.4166 years.
Can't you use that number? Gord Dibben MS Excel MVP On Sat, 12 Apr 2008 17:13:00 -0700, Paigem21 wrote: I did that. I need to put in 65 months for the Loan_Years but it says years only. I need it to calculate months instead of years. Can you help me? "Paigem21" wrote: I would like to change the loan period in an amortization schedule from year to months. Any sugestions on how to do this in a template that was downloaded? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the loan period in a amortization from years to mo
You can make your own payment schedule using the PMT function.
"Paigem21" wrote: I would like to change the loan period in an amortization schedule from year to months. Any sugestions on how to do this in a template that was downloaded? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the loan period in a amortization from years t
No I tried to do that but it said, "Please enter a whole number of years from
1 to 40" Is there any thing else I could do to change it to recognize months? "Gord Dibben" wrote: 65 months is 5.4166 years. Can't you use that number? Gord Dibben MS Excel MVP On Sat, 12 Apr 2008 17:13:00 -0700, Paigem21 wrote: I did that. I need to put in 65 months for the Loan_Years but it says years only. I need it to calculate months instead of years. Can you help me? "Paigem21" wrote: I would like to change the loan period in an amortization schedule from year to months. Any sugestions on how to do this in a template that was downloaded? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the loan period in a amortization from years t
I have never used that function before, can you give me some tips or an
example. It looks like it would be very usefule if I could learn how to use it properly. "Harimau" wrote: You can make your own payment schedule using the PMT function. "Paigem21" wrote: I would like to change the loan period in an amortization schedule from year to months. Any sugestions on how to do this in a template that was downloaded? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the loan period in a amortization from years t
Remove the data validation from that cell.
Select the cell and DataValidationClear all. Gord On Sun, 13 Apr 2008 08:15:00 -0700, Paigem21 wrote: No I tried to do that but it said, "Please enter a whole number of years from 1 to 40" Is there any thing else I could do to change it to recognize months? "Gord Dibben" wrote: 65 months is 5.4166 years. Can't you use that number? Gord Dibben MS Excel MVP On Sat, 12 Apr 2008 17:13:00 -0700, Paigem21 wrote: I did that. I need to put in 65 months for the Loan_Years but it says years only. I need it to calculate months instead of years. Can you help me? "Paigem21" wrote: I would like to change the loan period in an amortization schedule from year to months. Any sugestions on how to do this in a template that was downloaded? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change the payment period of amortization schedule | Excel Worksheet Functions | |||
Change years to months in loan amortization template | Excel Worksheet Functions | |||
How do I change the values in loan amortization | New Users to Excel | |||
loan amortization- how can I enter 4.75 years? no a whole number | Excel Discussion (Misc queries) | |||
Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) |