• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

currency number to words three decimal place

B

binoyfalcon

Member
Dear All,
I have excel formula for currency digit to words in two decimal place,
but i need three decimal places, eg: 350.500 , 486585.250
 

Attachments

  • currency to words.xlsx
    11.3 KB · Views: 7
Please try


="Kuwaiti DInar "&TRIM(INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(B7/10^11,10))+1)&IF(INT(MOD(B7/10^11,10))," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(B7/10^10,10)+1,MOD(B7/10^9,10)+1)&IF(INT(MOD(B7,10^12)/10^9)," Billion ","")&INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(B7/10^8,10))+1)&IF(INT(MOD(B7/10^8,10))," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(B7/10^7,10)+1,MOD(B7/10^6,10)+1)&IF(INT(MOD(B7,10^9)/10^6)," Million ","")
&INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(B7/10^5,10))+1)&IF(INT(MOD(B7/10^5,10))," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(B7/10^4,10)+1,MOD(B7/10^3,10)+1)&IF(INT(MOD(B7,10^6)/10^3)," Thousand ","")
&INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(B7/10^2,10))+1)&IF(INT(MOD(B7/10^2,10))," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(B7/10^1,10)+1,MOD(B7/10^0,10)+1)&IF(INT(B7),""," Zero")
&IF(MOD(B7,1)," and "&INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(INT(B7*10),10))+1)&IF(MOD(INT(B7*10),10)," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(INT(B7*100),10)+1,MOD(B7*1000,10)+1)&IF(MOD(B7,1)," Fills Only"," Zero"),"Only"))
 

Attachments

  • currency to words.xlsx
    12.8 KB · Views: 10
Excel Wizard said:
Please try


="Kuwaiti DInar "&TRIM(INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(B7/10^11,10))+1)&IF(INT(MOD(B7/10^11,10))," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(B7/10^10,10)+1,MOD(B7/10^9,10)+1)&IF(INT(MOD(B7,10^12)/10^9)," Billion ","")&INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(B7/10^8,10))+1)&IF(INT(MOD(B7/10^8,10))," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(B7/10^7,10)+1,MOD(B7/10^6,10)+1)&IF(INT(MOD(B7,10^9)/10^6)," Million ","")
&INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(B7/10^5,10))+1)&IF(INT(MOD(B7/10^5,10))," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(B7/10^4,10)+1,MOD(B7/10^3,10)+1)&IF(INT(MOD(B7,10^6)/10^3)," Thousand ","")
&INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(B7/10^2,10))+1)&IF(INT(MOD(B7/10^2,10))," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(B7/10^1,10)+1,MOD(B7/10^0,10)+1)&IF(INT(B7),""," Zero")
&IF(MOD(B7,1)," and "&INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},INT(MOD(INT(B7*10),10))+1)&IF(MOD(INT(B7*10),10)," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},{"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}&" "&{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}),MOD(INT(B7*100),10)+1,MOD(B7*1000,10)+1)&IF(MOD(B7,1)," Fills Only"," Zero"),"Only"))
Click to expand...

Thank you dear..... appreciate you taking time to help me. Your Excel knowledge is impressive!”
 
You must log in or register to reply here.
Back
Top