Multiply the number of periods by 12 and change the rate.
This last one depends on how it is calculated: simplest is divide by 12, but
you may need the EFECT or NOMINAL function to compute the rate. Depends on
your specs. See HELP for the functions.

--
Kind regards,

Niek Otten

"Linda V" <Linda wrote in message
...
How do I change formula to get loan period in months, not years?