How do I change the loan period in a amortization from years to mo

  • Thread starter Thread starter Paigem21
  • Start date Start date
P

Paigem21

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?
 
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?
 
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?
 
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.
 
Remove the data validation from that cell.

Select the cell and Data>Validation>Clear all.


Gord
 
Back
Top