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
|