=CHOOSE(LEFT(TEXT(B12,"000000000"))+1,,"One","Two" ,"Three","Four","Five","Six","Seven","Eight","Nine ")
&IF(--LEFT(TEXT(B12,"000000000"))=0,,IF(AND(--MID(TEXT(B12,"000000000"),2,1)=0,--MID(TEXT(B12,"000000000"),3,1)=0)," Hundred"," Hundred and "))
&CHOOSE(MID(TEXT(B12,"000000000"),2,1)+1,,,"Twe nty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
&IF(--MID(TEXT(B12,"000000000"),2,1)<>1,CHOOSE(MID(TEXT( B12,"000000000"),3,1)+1,,"One","Two","Three","Four ","Five","Six","Seven","Eight","Nine"),CHOOSE(MID( TEXT(B12,"000000000"),3,1)+1,"Ten","Eleven","Twelv e","Thirteen","Fourteen","Fifteen","Sixteen","Seve nteen","Eighteen","Nineteen"))
&IF((--LEFT(TEXT(B12,"000000000"))+MID(TEXT(B12,"00000000 0"),2,1)+MID(TEXT(B12,"000000000"),3,1))=0,,IF(AND ((--MID(TEXT(B12,"000000000"),4,1)+MID(TEXT(B12,"00000 0000"),5,1)+MID(TEXT(B12,"000000000"),6,1)+MID(TEX T(B12,"000000000"),7,1))=0,(--MID(TEXT(B12,"000000000"),8,1)+RIGHT(TEXT(B12,"000 000000")))>0)," Million and "," Million "))
&CHOOSE(MID(TEXT(B12,"000000000"),4,1)+1,,"One","T wo","Three","Four","Five","Six","Seven","Eight","N ine")
&IF(--MID(TEXT(B12,"000000000"),4,1)=0,,IF(AND(--MID(TEXT(B12,"000000000"),5,1)=0,--MID(TEXT(B12,"000000000"),6,1)=0)," Hundred"," Hundred and "))
&CHOOSE(MID(TEXT(B12,"000000000"),5,1)+1,,,"Twenty ","Thirty","Forty","Fifty","Sixty","Seventy","Eigh ty","Ninety")
&IF(--MID(TEXT(B12,"000000000"),5,1)<>1,CHOOSE(MID(TEXT( B12,"000000000"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(B12,"000000000"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen"))
&IF((--MID(TEXT(B12,"000000000"),4,1)+MID(TEXT(B12,"00000 0000"),5,1)+MID(TEXT(B12,"000000000"),6,1))=0,,IF( OR((--MID(TEXT(B12,"000000000"),7,1)+MID(TEXT(B12,"00000 0000"),8,1)+RIGHT(TEXT(B12,"000000000")))=0,--MID(TEXT(B12,"000000000"),7,1)<>0)," Thousand "," Thousand and "))
&CHOOSE(MID(TEXT(B12,"000000000"),7,1)+1,,"One","T wo","Three","Four","Five","Six","Seven","Eight","N ine")
&IF(--MID(TEXT(B12,"000000000"),7,1)=0,,IF(AND(--MID(TEXT(B12,"000000000"),8,1)=0,--RIGHT(TEXT(B12,"000000000"))=0)," Hundred "," Hundred and "))&
CHOOSE(MID(TEXT(B12,"000000000"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
&IF(--MID(TEXT(B12,"000000000"),8,1)<>1,CHOOSE(RIGHT(TEX T(B12,"000000000"))+1,,"One","Two","Three","Four", "Five","Six","Seven","Eight","Nine"),CHOOSE(RIGHT( TEXT(B12,"000000000"))+1,"Ten","Eleven","Twelve"," Thirteen","Fourteen","Fifteen","Sixteen","Seventee n","Eighteen","Nineteen"))
Bookmarks