Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
loan amortization- how can I enter 4.75 years? no a whole number
I am using the loan amortization template available for excel. The loan I am
using is for 4.75 years (4 years 9 months). The template will not allow me to use 4.75 years, it will only accept whole numbers between 1 and 30. Does anyone have any suggestions on how I can get around this? Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
loan amortization- how can I enter 4.75 years? no a whole number
maybe try 4.75?
-- Don Guillett SalesAid Software "andreaw" wrote in message ... I am using the loan amortization template available for excel. The loan I am using is for 4.75 years (4 years 9 months). The template will not allow me to use 4.75 years, it will only accept whole numbers between 1 and 30. Does anyone have any suggestions on how I can get around this? Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
loan amortization- how can I enter 4.75 years? no a whole num
The template will not allow me
to use 4.75 years, it will only accept whole numbers between 1 and 30. "Don Guillett" wrote: maybe try 4.75? -- Don Guillett SalesAid Software "andreaw" wrote in message ... I am using the loan amortization template available for excel. The loan I am using is for 4.75 years (4 years 9 months). The template will not allow me to use 4.75 years, it will only accept whole numbers between 1 and 30. Does anyone have any suggestions on how I can get around this? Thank you! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
loan amortization- how can I enter 4.75 years? no a whole number
Simply do the following steps: 1) unprotect the sheet 2) Click on the cell where you input the years 3) Select from menu DATA then VALIDATION 4) Select "ANY VALUE" in the Validation dialog window 5) "Increase decimal" spaces to 2 so that you can see 4.75 when you type it in there 6) Enter other values for your amortization table 7) BINGO! Heniek -- heniek ------------------------------------------------------------------------ heniek's Profile: http://www.excelforum.com/member.php...o&userid=34863 View this thread: http://www.excelforum.com/showthread...hreadid=546079 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
loan amortization- how can I enter 4.75 years? no a whole num
Thank You SO MUCH!!!
"heniek" wrote: Simply do the following steps: 1) unprotect the sheet 2) Click on the cell where you input the years 3) Select from menu DATA then VALIDATION 4) Select "ANY VALUE" in the Validation dialog window 5) "Increase decimal" spaces to 2 so that you can see 4.75 when you type it in there 6) Enter other values for your amortization table 7) BINGO! Heniek -- heniek ------------------------------------------------------------------------ heniek's Profile: http://www.excelforum.com/member.php...o&userid=34863 View this thread: http://www.excelforum.com/showthread...hreadid=546079 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loans aren't always an even number of years | Excel Discussion (Misc queries) | |||
Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) | |||
Loan amortization schedule | New Users to Excel | |||
Variable rate loan amortization template | Excel Discussion (Misc queries) | |||
The number change from 1350 to 13.5 and Enter does not function properly | Excel Discussion (Misc queries) |