{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Number to Word Without VBA","Number to Words With VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Number to Word Without VBA","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Converting Number to Word Without VBA",null,null,"Practice Yourself Here"]
[]
[null,"Number","Word",null,"Number","Word"]
[null,2.11,{"$f":"IF(OR(LEN(FLOOR(B5,1))=13,FLOOR(B5,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),3,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B5>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),6,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),9,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),12,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B5,1)>1,\" \",\" \"))&IF(ISERROR(FIND(\".\",B5,1)),\"\",\" point \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B5,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B5,\".\",REPT(\" \",255)),255,200)),2),\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"One\",\"One One\",\"One Two\",\"One Three\",\"One Four\",\"One Five\",\"One Six\",\"One Seven\",\"One Eight\",\"One Nine\")&\" \",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\")&\" \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B5,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B5,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")))))))","v":"Two  point One One "},null,2.11]
[null,555,{"$f":"IF(OR(LEN(FLOOR(B6,1))=13,FLOOR(B6,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),3,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B6>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),6,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),9,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),12,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B6,1)>1,\" \",\" \"))&IF(ISERROR(FIND(\".\",B6,1)),\"\",\" point \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B6,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B6,\".\",REPT(\" \",255)),255,200)),2),\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"One\",\"One One\",\"One Two\",\"One Three\",\"One Four\",\"One Five\",\"One Six\",\"One Seven\",\"One Eight\",\"One Nine\")&\" \",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\")&\" \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B6,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B6,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")))))))","v":"Five Hundred Fifty Five "},null,555]
[null,624,{"$f":"IF(OR(LEN(FLOOR(B7,1))=13,FLOOR(B7,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),3,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B7>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),6,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),9,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),12,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B7,1)>1,\" \",\" \"))&IF(ISERROR(FIND(\".\",B7,1)),\"\",\" point \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B7,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B7,\".\",REPT(\" \",255)),255,200)),2),\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"One\",\"One One\",\"One Two\",\"One Three\",\"One Four\",\"One Five\",\"One Six\",\"One Seven\",\"One Eight\",\"One Nine\")&\" \",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\")&\" \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B7,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B7,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")))))))","v":"Six Hundred Twenty Four "},null,624]
[null,897.99,{"$f":"IF(OR(LEN(FLOOR(B8,1))=13,FLOOR(B8,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),3,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B8>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),6,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),9,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),12,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B8,1)>1,\" \",\" \"))&IF(ISERROR(FIND(\".\",B8,1)),\"\",\" point \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B8,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B8,\".\",REPT(\" \",255)),255,200)),2),\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"One\",\"One One\",\"One Two\",\"One Three\",\"One Four\",\"One Five\",\"One Six\",\"One Seven\",\"One Eight\",\"One Nine\")&\" \",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\")&\" \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B8,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B8,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")))))))","v":"Eight Hundred Ninety Seven  point Nine Nine "},null,897.99]
[null,365,{"$f":"IF(OR(LEN(FLOOR(B9,1))=13,FLOOR(B9,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),3,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B9>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),6,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),9,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),12,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B9,1)>1,\" \",\" \"))&IF(ISERROR(FIND(\".\",B9,1)),\"\",\" point \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B9,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B9,\".\",REPT(\" \",255)),255,200)),2),\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"One\",\"One One\",\"One Two\",\"One Three\",\"One Four\",\"One Five\",\"One Six\",\"One Seven\",\"One Eight\",\"One Nine\")&\" \",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\")&\" \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B9,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B9,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")))))))","v":"Three Hundred Sixty Five "},null,365]
[null,89.55,{"$f":"IF(OR(LEN(FLOOR(B10,1))=13,FLOOR(B10,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),3,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B10>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),6,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),9,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),12,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B10),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B10),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B10,1)>1,\" \",\" \"))&IF(ISERROR(FIND(\".\",B10,1)),\"\",\" point \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B10,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B10,\".\",REPT(\" \",255)),255,200)),2),\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B10,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B10,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"One\",\"One One\",\"One Two\",\"One Three\",\"One Four\",\"One Five\",\"One Six\",\"One Seven\",\"One Eight\",\"One Nine\")&\" \",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B10,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B10,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\")&\" \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B10,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B10,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B10,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")))))))","v":"Eighty Nine  point Five Five "},null,89.55]
[null,69,{"$f":"IF(OR(LEN(FLOOR(B11,1))=13,FLOOR(B11,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),3,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B11>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),6,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),9,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),12,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B11),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B11),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B11,1)>1,\" \",\" \"))&IF(ISERROR(FIND(\".\",B11,1)),\"\",\" point \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B11,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B11,\".\",REPT(\" \",255)),255,200)),2),\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B11,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B11,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"One\",\"One One\",\"One Two\",\"One Three\",\"One Four\",\"One Five\",\"One Six\",\"One Seven\",\"One Eight\",\"One Nine\")&\" \",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B11,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B11,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\")&\" \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B11,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B11,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B11,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")))))))","v":"Sixty Nine "},null,69]
[null,125,{"$f":"IF(OR(LEN(FLOOR(B12,1))=13,FLOOR(B12,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),3,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B12>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),6,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),9,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),12,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B12),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B12),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B12,1)>1,\" \",\" \"))&IF(ISERROR(FIND(\".\",B12,1)),\"\",\" point \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B12,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B12,\".\",REPT(\" \",255)),255,200)),2),\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B12,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B12,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"One\",\"One One\",\"One Two\",\"One Three\",\"One Four\",\"One Five\",\"One Six\",\"One Seven\",\"One Eight\",\"One Nine\")&\" \",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B12,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B12,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\")&\" \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B12,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B12,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B12,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")))))))","v":"One Hundred Twenty Five "},null,125]
[null,345.26,{"$f":"IF(OR(LEN(FLOOR(B13,1))=13,FLOOR(B13,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),3,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B13>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),6,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),9,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),12,1)+1,\"\",\" one\",\" two\",\" three\",\" four\",\" five\",\" six\",\" seven\",\" eight\",\" nine\"),IF(VALUE(MID(TEXT(INT(B13),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B13),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B13,1)>1,\" \",\" \"))&IF(ISERROR(FIND(\".\",B13,1)),\"\",\" point \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B13,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B13,\".\",REPT(\" \",255)),255,200)),2),\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B13,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B13,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"One\",\"One One\",\"One Two\",\"One Three\",\"One Four\",\"One Five\",\"One Six\",\"One Seven\",\"One Eight\",\"One Nine\")&\" \",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B13,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B13,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\")&\" \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B13,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one \",IF(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B13,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('Number to Word Without VBA'!B13,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")&\" \",\"\")))))))","v":"Three Hundred Forty Five  point Two Six "},null,345.26]

{"sheet":"Number to Words With VBA","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Converting Number to Words With VBA",null,null,"Practice Yourself Here"]
[]
[null,"Number","Word",null,"Number","Word"]
[null,2.11,{"$f":" SpellNumber(B5)","v":" Two  point One  One  "},null,2.11]
[null,555,{"$f":" SpellNumber(B6)","v":"Five Hundred and Fifty Five "},null,555]
[null,624,{"$f":" SpellNumber(B7)","v":"Six Hundred and Twenty Four "},null,624]
[null,897.99,{"$f":" SpellNumber(B8)","v":"Eight Hundred and Ninety Seven  point Nine  Nine  "},null,897.99]
[null,365,{"$f":" SpellNumber(B9)","v":"Three Hundred and Sixty Five "},null,365]
[null,89.55,{"$f":" SpellNumber(B10)","v":" Eighty Nine  point Five  Five  "},null,89.55]
[null,69,{"$f":" SpellNumber(B11)","v":" Sixty Nine "},null,69]
[null,125,{"$f":" SpellNumber(B12)","v":"One Hundred and Twenty Five "},null,125]
[null,345.26,{"$f":" SpellNumber(B13)","v":"Three Hundred and Forty Five  point Two  Six  "},null,345.26]