Forum Discussion
Solved
How to change the Number of Years to Number of Months
I have TS0010197771.xlsx with Excel 2010. The Amortization is based on the number of years the loan is to be paid off. I have a loan that is 75 months; 6 years and 3 months.
How do I change the input field to accept months instead of years?
In the attached version, I cleaned up the terminology as best I could and removed the cell where you originally could enter the number of payments per year.
9 Replies
It would help if you attached a copy of the workbook without sensitive info, or made it available via OneDrive, Google Drive or similar.
Thank you!
The file is empty so you can do what needs to be done.
The link to the file is https://www.dropbox.com/scl/fi/qqbtydp18b1n2ysaonnn6/TS0010197771.xlsx?rlkey=awqn837av6zgueqrxpxlpbd3s&dl=0
Here you go.
