How to Convert Numbers to Words in Excel

How to Convert Numbers to Words in Excel

format Cell _(#,##0.00_);[Red](#,##0.00)

= CHOOSE(LEFT(TEXT(B3,"000000000000.00"))+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&IF(--LEFT(TEXT(B3,"000000000000.00"))=0, ,IF(AND(--MID(TEXT(B3,"000000000000.00"),2,1)=0,--MID(TEXT(B3,"000000000000.00"),3,1)=0),"Hundred ","Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(B3,"000000000000.00"),3,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine "),CHOOSE(MID(TEXT(B3,"000000000000.00"),3,1)+1,"Ten ","Eleven ","Twelve ","Thirteen ","Fourteen ","Fifteen ","Sixteen ","Seventeen ","Eighteen ","Nineteen "))&IF((--LEFT(TEXT(B3,"000000000000.00"))+MID(TEXT(B3,"000000000000.00"),2,1)+MID(TEXT(B3,"000000000000.00"),3,1))=0, ,IF(AND((--MID(TEXT(B3,"000000000000.00"),4,1)+MID(TEXT(B3,"000000000000.00"),5,1)+MID(TEXT(B3,"000000000000.00"),6,1)+MID(TEXT(B3,"000000000000.00"),7,1))=0,(--MID(TEXT(B3,"000000000000.00"),8,1)+RIGHT(TEXT(B3,"000000000000.00")))>0),"Billion and ","Billion "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),4,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&IF(--MID(TEXT(B3,"000000000000.00"),4,1)=0, ,IF(AND(--MID(TEXT(B3,"000000000000.00"),5,1)=0,--MID(TEXT(B3,"000000000000.00"),6,1)=0),"Hundred ","Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),5,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(B3,"000000000000.00"),6,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine "),CHOOSE(MID(TEXT(B3,"000000000000.00"),6,1)+1,"Ten ","Eleven ","Twelve ","Thirteen ","Fourteen ","Fifteen ","Sixteen ","Seventeen ","Eighteen ","Nineteen "))&IF((--MID(TEXT(B3,"000000000000.00"),4,1)+MID(TEXT(B3,"000000000000.00"),5,1)+MID(TEXT(B3,"000000000000.00"),6,1))=0, ,IF(OR((--MID(TEXT(B3,"000000000000.00"),7,1)+MID(TEXT(B3,"000000000000.00"),8,1)+MID(TEXT(B3,"000000000000.00"),9,1))=0,--MID(TEXT(B3,"000000000000.00"),7,1)>0),"Million ","Million and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),7,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&IF(--MID(TEXT(B3,"000000000000.00"),7,1)=0, ,IF(AND(--MID(TEXT(B3,"000000000000.00"),8,1)=0,--MID(TEXT(B3,"000000000000.00"),9,1)=0),"Hundred ","Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(B3,"000000000000.00"),9,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine "),CHOOSE(MID(TEXT(B3,"000000000000.00"),9,1)+1,"Ten ","Eleven ","Twelve ","Thirteen ","Fourteen ","Fifteen ","Sixteen ","Seventeen ","Eighteen ","Nineteen "))&IF((--MID(TEXT(B3,"000000000000.00"),7,1)+MID(TEXT(B3,"000000000000.00"),8,1)+MID(TEXT(B3,"000000000000.00"),9,1))=0, ,IF(OR((--MID(TEXT(B3,"000000000000.00"),10,1)+MID(TEXT(B3,"000000000000.00"),11,1)+MID(TEXT(B3,"000000000000.00"),12,1))=0,--MID(TEXT(B3,"000000000000.00"),10,1)<>0),"Thousand ","Thousand and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),10,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&IF(--MID(TEXT(B3,"000000000000.00"),10,1)=0, ,IF(AND(--MID(TEXT(B3,"000000000000.00"),11,1)=0,--MID(TEXT(B3,"000000000000.00"),12,1)=0),"Hundred ","Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000000.00"),11,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000000.00"),11,1)<>1,CHOOSE(MID(TEXT(B3,"000000000000.00"),12,1)+1,,"One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine "),CHOOSE(MID(TEXT(B3,"000000000000.00"),12,1)+1,"Ten ","Eleven ","Twelve ","Thirteen ","Fourteen ","Fifteen ","Sixteen ","Seventeen ","Eighteen ","Nineteen "))&"Doller and Cent "&CHOOSE(MID(TEXT(B3,"000000000000.00"),14,1)+2,,"zero ","One ","Two ","Three ","Four ","Five ","Six ","Seven ","Eight ","Nine ")&CHOOSE(MID(TEXT(B3,"000000000000.00"),15,1)+2,,"zero","One","Two","Three","Four","Five","Six","Seven","Eight","Nine")& " USD Only"