XRStr = xRStr & RupeeFormat_GetD(Right(xTStr, 1))įunction RupeeFormat_GetD(xDStr As String) XTArr1 = Array("Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen") XRStr = xRStr & RupeeFormat_GetD(Mid(xStrH, 3))įunction RupeeFormat_GetT(xTStr As String) XRStr = xRStr & RupeeFormat_GetT(Mid(xStrH, 2)) XRStr = RupeeFormat_GetD(Mid(xStrH, 1, 1)) & " Hundred " XRStr = RupeeFormat_GetD(Mid(xStrH, 1, 1)) & " Lac " RupeeFormat = xRStr & xRStr_Paisas & " Only"įunction RupeeFormat_GetH(xStrH As String, xLp As Integer) XRStr_Paisas = " and " & xRStr_Paisas & " Paisas" XNumStr = Left(xNumStr, Len(xNumStr) - 3) XNumStr = Left(xNumStr, Len(xNumStr) - 2) XStrTemp = RupeeFormat_GetT(Right(xTemp, 2)) XStrTemp = RupeeFormat_GetH(Right(xTemp, 3), xLp) XNumStr = Trim(Left(xNumStr, xDPInt - 1)) XRStr_Paisas = RupeeFormat_GetT(Left(Mid(xNumStr, xDPInt + 1), 2)) XRStr_Paisas = RupeeFormat_GetT(Left(Mid(xNumStr, xDPInt + 1) & "0", 2)) RupeeFormat = "Digit excced Maximum limit" Public Function RupeeFormat(SNum As String) Step 5: Paste the VBA code provided in the reference. Step 3: Click on Visual Basic or use the keyboard shortcut Alt + F11 If you don't see this tab, follow the step above to enable it Step 5: Find developer in the list and click addįree download Now here is the step to convert numbers to words in Indian Rupees using VBA code: Step 4: Choose all tab in the Choose command form option Step 3: In the excel Option choose customize ribbon Step 2: Click on file and choose option in the list Step 1: Open the Excel spreadsheet that contains the numbers you want to convert. Here is the step to enable the developer tab in Excel: 2 Easy Ways to Convert Numbers to Words in Indian Rupees in Excel: Method 1: Convert numbers to words in Indian rupees with VBA codeīefore converting numbers to words in Indian Rupees using VBA code, you may need to add on the developer tab in your ribbon to open the VBA function. In this guide, we'll teach you a simple step-by-step method to convert numbers into words for Indian Rupees using Excel. So, you might end up using complicated formulas, external tools, or doing it manually. But Excel doesn't have a built-in way to do this, especially for Indian Rupees. When you're working with numbers in Excel, sometimes you need to show them in both numbers and words for official documents or clarity.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |