I am wanting to use the loan amortization spread sheet, and was wondering how
you change the values as I want to change Loan period in Years to calculate
Loan period in Months?? I have tried several things but not having a great
knowledge on using Excel im failing miserably! PLEASE HELP!!! :O)


Thank you!

a combination of dividing by 12 and multiplying by 12. play with it

--
Don Guillett
SalesAid Software

"ROXYAWORLD" wrote in message
...
I am wanting to use the loan amortization spread sheet, and was wondering
how
you change the values as I want to change Loan period in Years to
calculate
Loan period in Months?? I have tried several things but not having a great
knowledge on using Excel im failing miserably! PLEASE HELP!!! :O)


Thank you!

Hello:

There are several different loan amortization templates on MS's website
Try using 01056620.xlt. This is a monthly one. You can find it in
the real estate subsection. Or try the following link.

http://office.microsoft.com/en-us/te...566201033.aspx

Pieter Vandenberg


ROXYAWORLD wrote:
: I am wanting to use the loan amortization spread sheet, and was wondering how
: you change the values as I want to change Loan period in Years to calculate
: Loan period in Months?? I have tried several things but not having a great
: knowledge on using Excel im failing miserably! PLEASE HELP!!! :O)


: Thank you!