Why will the loan term cell only accept whole numbers? Is Data Validation
turned on? Give us more details about the spreadsheet you're using.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"sc" wrote:

My loan term is 3.5 years. How can i calculate payments when the table will
only accept full years in the loan term cell?