Apply the following formula:=AdvancedWord(B5) Drag theFill Handleicon to copy the formula down. I am also attaching the solution workbook for better understanding. I hope the solution will help you; good luck. Excel & VBA Developer ExcelDemy Lutfor Rahman ShimantoMay 9, 2024 at 11:32 AM D...
Excel does not provide any default function that converts a number or amount in words in Indian rupees or any currency. But it doesn't mean that we can't convert number to Indian rupee. We can create a custom Excel formula to convert number to words in Indian rupees. I have created th...
3. After inserting the code, save and close the code window, go back to the worksheet, and enter this formula: =RupeeFormat(A2) into a blank cell, and then drag the fill handle down to apply this formula to other cells, all the numbers have been spelled out in rupees, see screenshot...