Select the range of cellsH11:H17, and in theDatatab, clickData Validationand selectData Validationfrom the groupData Tools. TheData Validationdialog box will appear. Change theAllowfield fromAny valuetoList, and in theSourcefield, write down “Debit,Credit“. ClickOK. You will find the data ...
Write down 0 in the box of Decimal places and choose the dollar sign ($) from the Symbol drop-down list. Click OK. Step 2 – Make a Monthly Ledger in Excel Select cell G3 and insert the following formula. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&" "...
Create a Tally Function (fnTally) Points: 1003975 More actions May 13, 2008 at 8:14 am #814500 The only thing that might beat the method in the article would be to maintain a separate table with a list of accounts and the current balance (1 row each) of each. Even then, you shoul...