This code is helpful to get the output for Dollar... $word = numberTowords(100045.95); echo $word; exit(); function numberTowords($num) { $ones = array( 0 =>"ZERO", 1 => "ONE", 2 => "TWO", 3 => "THREE", 4 => "FOUR", 5 => "FIVE", 6 => "SIX", 7 => "SEVE...
Functionnumber_converting_into_words(ByValMyNumber)Dimx_stringAsStringDimwhole_numAsIntegerDimx_string_pntDimx_string_NumDimx_pntAsStringDimx_numbAsStringDimx_P()AsVariantDimx_DPDimx_cntAsIntegerDimx_output,x_TAsStringDimx_my_lenAsIntegerOnErrorResumeNextx_P=Array("","Thousand ","Million ",...
How to Convert Number to Words in Excel in Rupees:We can create a custom Excel formula to convert numbers to words in Indian rupees. I have created this custom function to convert numbers to words in terms of Indian rupees. You can download the macro file ...
copy the above code language in a word sheet replace word "dollar" with "Rupees" Then Replace word "cents" with "Paisa" go back to excel file press alt+F11 insert>>> module >> paste the entire word file till "end function" do ...=SpellNumberToEnglish(cellref) & you are good to g...
Code 1 Function Convert_Number_into_word_with_currency(ByVal whole_number) Dim converted_into_dollar, converted_into_cent my_ary = Array("", "", " Thousand ", " Million ", " Billion ", " Trillion ") whole_number = Trim(Str(whole_number)) ...
Optional CurrSYMSingular = DEFAULT Value = "RUPEE", 'for example USD or US DOLLAR, INR or Indian Rupee for one unit of currency, Default Value Rupee Optional CurrSYMPlural = DEFAULT Value = "RUPEES", for example USDs or US DOLLARs, INRs or Indian Rupees for multiple units of currency...
You can also enter the number directly into the function, for example,=SpellNumber(29.95)(29.95 - without quotation marks and the Dollar sign). Disadvantages of using macro to spell numbers in Excel First off, you must know VBA to modify the code according to your needs. It is necessary to...