Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error Message
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
It's me again!! Error message. | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
#num! error message | Excel Worksheet Functions |