While in the cel, go to Data Validaton and remove the error checking for
the cell.

"RS" wrote:

I am using a predesigned template from Microsoft for Loan Amortization. I
want to enter a decimal number instead of a whole number in the cell for
years. Every time I try to enter a decimal, it gives me the error message
"Please enter a whole number of years from 1 to 40".

I tried to unprotect the sheet, did my own field in another cell, but would
like to know how to correct the error on this cell.

Does anyone have any experience with this type of error?

Thank you!!