Function NumberToWords(ByVal MyNumber) ' Works for numbers up to 99999 Dim Rupees, Paise, Temp Dim DecimalPlace, Count ... End Function
Under rules:
What if you could generate a ? Not only does this save time, but it also ensures accuracy, reduces paper waste, and allows you to maintain a digital record of your deposits.
| | Description | | --- | --- | | Date | Date of deposit | | Account Number | Account number of the depositor | | Depositor's Name | Name of the depositor | | Amount | Amount being deposited | | Deposit Type | Type of deposit (cash/cheque) |
You enter the count of notes (e.g., 500s, 200s, 100s), and Excel calculates the Total Amount instantly.
You might wonder—why not just pick up a free pad of slips from the bank? Here are compelling reasons to switch to an Excel-based system:
For customers of Punjab National Bank (PNB), one of India’s largest public sector banks, depositing cash into a savings or current account is a routine task. Traditionally, this involves standing in long queues at bank branches, manually filling out a physical deposit slip, and waiting for a teller’s stamp. However, in the digital age, efficiency matters.