linkmaio.blogg.se

Result = Result & GetDigit(Mid(MyNumber, 3)) Result = Result & GetTens(Mid(MyNumber, 2)) Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "

' Converts a number from 100-999 into text NUM_TO_IND_RUPEE_WORD = IIf(incRupees, "Rupees ", "") & Crores & _ Lakhs & Rupees & Paise 'creating the string of words to translate number into words MyNumber = Left(MyNumber, Len(MyNumber) - 3)Ĭase "One": Paise = " and Paise One Only "Ĭase Else: Paise = " and Paise " & Paise & " Only " If Temp "" Then Rupees = Temp & Place(Count) & Rupees MyLakhs = Left(myLakhs, Len(myLakhs) - 3) If Temp "" Then Lakhs = Temp & Place(Count) & Lakhs M圜rores = Left(m圜rores, Len(m圜rores) - 3) If Temp "" Then Crores = Temp & Place(Count) & Crores MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) Paise = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)) ' Convert Paise and set MyNumber to Rupees amount. Place(4) = " Billion ": Place(5) = " Trillion " Place(2) = " Thousand ": Place(3) = " Million " Function NUM_TO_IND_RUPEE_WORD(ByVal MyNumber, Optional incRupees As Boolean = True) And other three functions GetHunderds(), GetTens() and GetDigits are helping function that help the main function to form the string. The main function is NUM_TO_IND_RUPEE_WORD. This code is divided into four individual functions. Now the code of the function is mentioned below. You can download the working macro file down: The syntax of this function is: =NUM_TO_IND_RUPEE_WORD(number) I have named this function NUM_TO_IND_RUPEE_WORD.

So use this function to convert the any 10 digit or less amount or number into words or rupees. Excel Function to Covert Number to Words in Indian Rupees I have mentioned the code below and explained a little bit, so that you can make changes as per your requirement. I have created this custom function to convert number to words in terms of Indian rupees. We can create a custom Excel formula to convert number to words in Indian rupees. But it doesn't mean that we can't convert number to Indian rupee. Excel does not provide any default function that converts a number or amount in words in Indian rupees or any currency.