{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dataset","Excel Formula","Using 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":"Dataset","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Spelling Numbers in Excel"]
[]
[null,"Numbers","Spelled Numbers"]
[null,20672.45]
[null,30651.19]
[null,23518]
[null,45847.81]
[null,65190.239999999998]
[null,8432.99]
[null,70680.179999999993]

{"sheet":"Excel Formula","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using Excel Formula to Spell Numbers ",null,null,null,null,"Practice Section"]
[]
[null,"Numbers","Spelled Numbers",null,null,null,"Numbers","Spelled Numbers"]
[null,20672.45,{"$f":"CHOOSE(LEFT(TEXT(B5,\"000000000000.00\"))+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&IF(--LEFT(TEXT(B5,\"000000000000.00\"))=0, ,IF(AND(--MID(TEXT(B5,\"000000000000.00\"),2,1)=0,--MID(TEXT(B5,\"000000000000.00\"),3,1)=0),\"Hundred \",\"Hundred and \"))&CHOOSE(MID(TEXT(B5,\"000000000000.00\"),2,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")&IF(--MID(TEXT(B5,\"000000000000.00\"),2,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000000.00\"),3,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \"),CHOOSE(MID(TEXT(B5,\"000000000000.00\"),3,1)+1,\"Ten \",\"Eleven \",\"Twelve \",\"Thirteen \",\"Fourteen \",\"Fifteen \",\"Sixteen \",\"Seventeen \",\"Eighteen \",\"Nineteen \"))&IF((--LEFT(TEXT(B5,\"000000000000.00\"))+MID(TEXT(B5,\"000000000000.00\"),2,1)+MID(TEXT(B5,\"000000000000.00\"),3,1))=0, ,IF(AND((--MID(TEXT(B5,\"000000000000.00\"),4,1)+MID(TEXT(B5,\"000000000000.00\"),5,1)+MID(TEXT(B5,\"000000000000.00\"),6,1)+MID(TEXT(B5,\"000000000000.00\"),7,1))=0,(--MID(TEXT(B5,\"000000000000.00\"),8,1)+RIGHT(TEXT(B5,\"000000000000.00\")))>0),\"Billion and \",\"Billion \"))&CHOOSE(MID(TEXT(B5,\"000000000000.00\"),4,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&IF(--MID(TEXT(B5,\"000000000000.00\"),4,1)=0, ,IF(AND(--MID(TEXT(B5,\"000000000000.00\"),5,1)=0,--MID(TEXT(B5,\"000000000000.00\"),6,1)=0),\"Hundred \",\"Hundred and \"))&CHOOSE(MID(TEXT(B5,\"000000000000.00\"),5,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")&IF(--MID(TEXT(B5,\"000000000000.00\"),5,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000000.00\"),6,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \"),CHOOSE(MID(TEXT(B5,\"000000000000.00\"),6,1)+1,\"Ten \",\"Eleven \",\"Twelve \",\"Thirteen \",\"Fourteen \",\"Fifteen \",\"Sixteen \",\"Seventeen \",\"Eighteen \",\"Nineteen \"))&IF((--MID(TEXT(B5,\"000000000000.00\"),4,1)+MID(TEXT(B5,\"000000000000.00\"),5,1)+MID(TEXT(B5,\"000000000000.00\"),6,1))=0, ,IF(OR((--MID(TEXT(B5,\"000000000000.00\"),7,1)+MID(TEXT(B5,\"000000000000.00\"),8,1)+MID(TEXT(B5,\"000000000000.00\"),9,1))=0,--MID(TEXT(B5,\"000000000000.00\"),7,1)>0),\"Million \",\"Million and \"))&CHOOSE(MID(TEXT(B5,\"000000000000.00\"),7,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&IF(--MID(TEXT(B5,\"000000000000.00\"),7,1)=0, ,IF(AND(--MID(TEXT(B5,\"000000000000.00\"),8,1)=0,--MID(TEXT(B5,\"000000000000.00\"),9,1)=0),\"Hundred \",\"Hundred and \"))&CHOOSE(MID(TEXT(B5,\"000000000000.00\"),8,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")&IF(--MID(TEXT(B5,\"000000000000.00\"),8,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000000.00\"),9,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \"),CHOOSE(MID(TEXT(B5,\"000000000000.00\"),9,1)+1,\"Ten \",\"Eleven \",\"Twelve \",\"Thirteen \",\"Fourteen \",\"Fifteen \",\"Sixteen \",\"Seventeen \",\"Eighteen \",\"Nineteen \"))&IF((--MID(TEXT(B5,\"000000000000.00\"),7,1)+MID(TEXT(B5,\"000000000000.00\"),8,1)+MID(TEXT(B5,\"000000000000.00\"),9,1))=0, ,IF(OR((--MID(TEXT(B5,\"000000000000.00\"),10,1)+MID(TEXT(B5,\"000000000000.00\"),11,1)+MID(TEXT(B5,\"000000000000.00\"),12,1))=0,--MID(TEXT(B5,\"000000000000.00\"),10,1)<>0),\"Thousand \",\"Thousand and \"))&CHOOSE(MID(TEXT(B5,\"000000000000.00\"),10,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&IF(--MID(TEXT(B5,\"000000000000.00\"),10,1)=0, ,IF(AND(--MID(TEXT(B5,\"000000000000.00\"),11,1)=0,--MID(TEXT(B5,\"000000000000.00\"),12,1)=0),\"Hundred \",\"Hundred and \"))&CHOOSE(MID(TEXT(B5,\"000000000000.00\"),11,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")&IF(--MID(TEXT(B5,\"000000000000.00\"),11,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000000.00\"),12,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \"),CHOOSE(MID(TEXT(B5,\"000000000000.00\"),12,1)+1,\"Ten \",\"Eleven \",\"Twelve \",\"Thirteen \",\"Fourteen \",\"Fifteen \",\"Sixteen \",\"Seventeen \",\"Eighteen \",\"Nineteen \"))&\"Point \"&CHOOSE(MID(TEXT(B5,\"000000000000.00\"),14,1)+2,,\"zero \",\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&CHOOSE(MID(TEXT(B5,\"000000000000.00\"),15,1)+2,,\"zero\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")","v":"Twenty Thousand Six Hundred and Seventy Two Point Four Five"},null,null,null,20672.45]
[null,30651.19,{"$f":"CHOOSE(LEFT(TEXT(B6,\"000000000000.00\"))+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&IF(--LEFT(TEXT(B6,\"000000000000.00\"))=0, ,IF(AND(--MID(TEXT(B6,\"000000000000.00\"),2,1)=0,--MID(TEXT(B6,\"000000000000.00\"),3,1)=0),\"Hundred \",\"Hundred and \"))&CHOOSE(MID(TEXT(B6,\"000000000000.00\"),2,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")&IF(--MID(TEXT(B6,\"000000000000.00\"),2,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000000.00\"),3,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \"),CHOOSE(MID(TEXT(B6,\"000000000000.00\"),3,1)+1,\"Ten \",\"Eleven \",\"Twelve \",\"Thirteen \",\"Fourteen \",\"Fifteen \",\"Sixteen \",\"Seventeen \",\"Eighteen \",\"Nineteen \"))&IF((--LEFT(TEXT(B6,\"000000000000.00\"))+MID(TEXT(B6,\"000000000000.00\"),2,1)+MID(TEXT(B6,\"000000000000.00\"),3,1))=0, ,IF(AND((--MID(TEXT(B6,\"000000000000.00\"),4,1)+MID(TEXT(B6,\"000000000000.00\"),5,1)+MID(TEXT(B6,\"000000000000.00\"),6,1)+MID(TEXT(B6,\"000000000000.00\"),7,1))=0,(--MID(TEXT(B6,\"000000000000.00\"),8,1)+RIGHT(TEXT(B6,\"000000000000.00\")))>0),\"Billion and \",\"Billion \"))&CHOOSE(MID(TEXT(B6,\"000000000000.00\"),4,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&IF(--MID(TEXT(B6,\"000000000000.00\"),4,1)=0, ,IF(AND(--MID(TEXT(B6,\"000000000000.00\"),5,1)=0,--MID(TEXT(B6,\"000000000000.00\"),6,1)=0),\"Hundred \",\"Hundred and \"))&CHOOSE(MID(TEXT(B6,\"000000000000.00\"),5,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")&IF(--MID(TEXT(B6,\"000000000000.00\"),5,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000000.00\"),6,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \"),CHOOSE(MID(TEXT(B6,\"000000000000.00\"),6,1)+1,\"Ten \",\"Eleven \",\"Twelve \",\"Thirteen \",\"Fourteen \",\"Fifteen \",\"Sixteen \",\"Seventeen \",\"Eighteen \",\"Nineteen \"))&IF((--MID(TEXT(B6,\"000000000000.00\"),4,1)+MID(TEXT(B6,\"000000000000.00\"),5,1)+MID(TEXT(B6,\"000000000000.00\"),6,1))=0, ,IF(OR((--MID(TEXT(B6,\"000000000000.00\"),7,1)+MID(TEXT(B6,\"000000000000.00\"),8,1)+MID(TEXT(B6,\"000000000000.00\"),9,1))=0,--MID(TEXT(B6,\"000000000000.00\"),7,1)>0),\"Million \",\"Million and \"))&CHOOSE(MID(TEXT(B6,\"000000000000.00\"),7,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&IF(--MID(TEXT(B6,\"000000000000.00\"),7,1)=0, ,IF(AND(--MID(TEXT(B6,\"000000000000.00\"),8,1)=0,--MID(TEXT(B6,\"000000000000.00\"),9,1)=0),\"Hundred \",\"Hundred and \"))&CHOOSE(MID(TEXT(B6,\"000000000000.00\"),8,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")&IF(--MID(TEXT(B6,\"000000000000.00\"),8,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000000.00\"),9,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \"),CHOOSE(MID(TEXT(B6,\"000000000000.00\"),9,1)+1,\"Ten \",\"Eleven \",\"Twelve \",\"Thirteen \",\"Fourteen \",\"Fifteen \",\"Sixteen \",\"Seventeen \",\"Eighteen \",\"Nineteen \"))&IF((--MID(TEXT(B6,\"000000000000.00\"),7,1)+MID(TEXT(B6,\"000000000000.00\"),8,1)+MID(TEXT(B6,\"000000000000.00\"),9,1))=0, ,IF(OR((--MID(TEXT(B6,\"000000000000.00\"),10,1)+MID(TEXT(B6,\"000000000000.00\"),11,1)+MID(TEXT(B6,\"000000000000.00\"),12,1))=0,--MID(TEXT(B6,\"000000000000.00\"),10,1)<>0),\"Thousand \",\"Thousand and \"))&CHOOSE(MID(TEXT(B6,\"000000000000.00\"),10,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&IF(--MID(TEXT(B6,\"000000000000.00\"),10,1)=0, ,IF(AND(--MID(TEXT(B6,\"000000000000.00\"),11,1)=0,--MID(TEXT(B6,\"000000000000.00\"),12,1)=0),\"Hundred \",\"Hundred and \"))&CHOOSE(MID(TEXT(B6,\"000000000000.00\"),11,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")&IF(--MID(TEXT(B6,\"000000000000.00\"),11,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000000.00\"),12,1)+1,,\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \"),CHOOSE(MID(TEXT(B6,\"000000000000.00\"),12,1)+1,\"Ten \",\"Eleven \",\"Twelve \",\"Thirteen \",\"Fourteen \",\"Fifteen \",\"Sixteen \",\"Seventeen \",\"Eighteen \",\"Nineteen \"))&\"Point \"&CHOOSE(MID(TEXT(B6,\"000000000000.00\"),14,1)+2,,\"zero \",\"One \",\"Two \",\"Three \",\"Four \",\"Five \",\"Six \",\"Seven \",\"Eight \",\"Nine \")&CHOOSE(MID(TEXT(B6,\"000000000000.00\"),15,1)+2,,\"zero\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")","v":"Thirty Thousand Six Hundred and Fifty One Point One Nine"},null,null,null,30651.19]
[null,23518,"Twenty Three Thousand Five Hundred and Eighteen Point zero zero",null,null,null,23518]
[null,45847.81,"Forty Five Thousand Eight Hundred and Forty Seven Point Eight One",null,null,null,45847.81]
[null,65190.239999999998,"Sixty Five Thousand One Hundred and Ninety Point Two Four",null,null,null,65190.239999999998]
[null,8432.99,"Eight Thousand Four Hundred and Thirty Two Point Nine Nine",null,null,null,8432.99]
[null,70680.179999999993,"Seventy Thousand Six Hundred and Eighty Point One Eight",null,null,null,70680.179999999993]

{"sheet":"Using VBA ","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Utilizing Excel VBA to Spell Numbers ",null,null,null,null,null,"Practice Section"]
[]
[null,"Numbers","Spelled Numbers",null,null,null,null,"Numbers","Spelled Numbers"]
[null,20672.45,{"$f":"spelling_number(B5)","v":"Twenty  Thousand Six Hundred Seventy Two Point Four Five "},null,null,null,null,20672.45]
[null,30651.19,{"$f":"spelling_number(B6)","v":"Thirty  Thousand Six Hundred Fifty One Point One Nine "},null,null,null,null,30651.19]
[null,23518,{"$f":"spelling_number(B7)","v":"Twenty Three Thousand Five Hundred Eighteen"},null,null,null,null,23518]
[null,45847.81,{"$f":"spelling_number(B8)","v":"Forty Five Thousand Eight Hundred Forty Seven Point Eight One "},null,null,null,null,45847.81]
[null,65190.239999999998,{"$f":"spelling_number(B9)","v":"Sixty Five Thousand One Hundred Ninety  Point Two Four "},null,null,null,null,65190.239999999998]
[null,8432.99,{"$f":"spelling_number(B10)","v":"Eight Thousand Four Hundred Thirty Two Point Nine Nine "},null,null,null,null,8432.99]
[null,70680.179999999993,{"$f":"spelling_number(B11)","v":"Seventy  Thousand Six Hundred Eighty  Point One Eight "},null,null,null,null,70680.179999999993]