Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I downloaded the Loan Amortization Schedule from Excel 2003...what is data
validation? Thank you "Dave F" wrote: 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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can you provide a link to the template so someone can download and take a
look at it? Data validation is a tool used in Excel to restrict entries in a cell to a specified list of values, such as whole numbers. 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: I downloaded the Loan Amortization Schedule from Excel 2003...what is data validation? Thank you "Dave F" wrote: 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? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I just went onto Office Help online and found a loan amortization table that
accepted partial years...the version I was using before I found through the help menu while I was in Excel. I think the one i found online is going to work...thank you "Dave F" wrote: Can you provide a link to the template so someone can download and take a look at it? Data validation is a tool used in Excel to restrict entries in a cell to a specified list of values, such as whole numbers. 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: I downloaded the Loan Amortization Schedule from Excel 2003...what is data validation? Thank you "Dave F" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Amortization Table | Charts and Charting in Excel | |||
45 day Amortization Template | Excel Discussion (Misc queries) | |||
amortization table | Excel Discussion (Misc queries) | |||
Amortization 30/365 | Excel Worksheet Functions | |||
Amortization | Excel Worksheet Functions |