{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1. Combined Functions","2. VLOOKUP","3. VBA Macro Method - Numeric","4. VBA Macro Method - Monetary","1. TEXT Function Method","2. Format Cell Method","3. The Apostrophe (') method"],"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":"1. Combined Functions","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Combined Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Numbers","Numbers in Words",null,null,null,null,null,null,"Numbers","Numbers in Words"]
[null,12345,{"$f":"CHOOSE(LEFT(TEXT(B5,\"000000000.00\"))+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--LEFT(TEXT(B5,\"000000000.00\"))=0,,IF(AND(--MID(TEXT(B5,\"000000000.00\"),2,1)=0,--MID(TEXT(B5,\"000000000.00\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&CHOOSE(MID(TEXT(B5,\"000000000.00\"),2,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B5,\"000000000.00\"),2,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000.00\"),3,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),\nCHOOSE(MID(TEXT(B5,\"000000000.00\"),3,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))\n&IF((--LEFT(TEXT(B5,\"000000000.00\"))+MID(TEXT(B5,\"000000000.00\"),2,1)+MID(TEXT(B5,\"000000000.00\"),3,1))=0,,IF(AND((--MID(TEXT(B5,\"000000000.00\"),4,1)+MID(TEXT(B5,\"000000000.00\"),5,1)+MID(TEXT(B5,\"000000000.00\"),6,1)+MID(TEXT(B5,\"000000000.00\"),7,1))=0,(--MID(TEXT(B5,\"000000000.00\"),8,1)+RIGHT(TEXT(B5,\"000000000.00\")))>0),\" Million and \",\" Million \"))\n&CHOOSE(MID(TEXT(B5,\"000000000.00\"),4,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B5,\"000000000.00\"),4,1)=0,,IF(AND(--MID(TEXT(B5,\"000000000.00\"),5,1)=0,--MID(TEXT(B5,\"000000000.00\"),6,1)=0),\" Hundred\",\" Hundred and\"))\n&CHOOSE(MID(TEXT(B5,\"000000000.00\"),5,1)+1,,,\" Twenty\",\" Thirty\",\" Forty\",\" Fifty\",\" Sixty\",\" Seventy\",\" Eighty\",\" Ninety\")\n&IF(--MID(TEXT(B5,\"000000000.00\"),5,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000.00\"),6,1)+1,,\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\"),CHOOSE(MID(TEXT(B5,\"000000000.00\"),6,1)+1,\" Ten\",\" Eleven\",\" Twelve\",\" Thirteen\",\" Fourteen\",\" Fifteen\",\" Sixteen\",\" Seventeen\",\" Eighteen\",\" Nineteen\"))\n&IF((--MID(TEXT(B5,\"000000000.00\"),4,1)+MID(TEXT(B5,\"000000000.00\"),5,1)+MID(TEXT(B5,\"000000000.00\"),6,1))=0,,IF(OR((--MID(TEXT(B5,\"000000000.00\"),7,1)+MID(TEXT(B5,\"000000000.00\"),8,1)+MID(TEXT(B5,\"000000000.00\"),9,1))=0,--MID(TEXT(B5,\"000000000.00\"),7,1)<>0),\" Thousand \",\" Thousand and \"))\n&CHOOSE(MID(TEXT(B5,\"000000000.00\"),7,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B5,\"000000000.00\"),7,1)=0,,IF(AND(--MID(TEXT(B5,\"000000000.00\"),8,1)=0,--MID(TEXT(B5,\"000000000.00\"),9,1)=0),\" Hundred \",\" Hundred and \"))&\nCHOOSE(MID(TEXT(B5,\"000000000.00\"),8,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B5,\"000000000.00\"),8,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000.00\"),9,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),CHOOSE(MID(TEXT(B5,\"000000000.00\"),9,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))","v":" Twelve Thousand Three Hundred and Forty Five"},null,null,null,null,null,null,12345]
[null,23456,{"$f":"CHOOSE(LEFT(TEXT(B6,\"000000000.00\"))+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--LEFT(TEXT(B6,\"000000000.00\"))=0,,IF(AND(--MID(TEXT(B6,\"000000000.00\"),2,1)=0,--MID(TEXT(B6,\"000000000.00\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&CHOOSE(MID(TEXT(B6,\"000000000.00\"),2,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B6,\"000000000.00\"),2,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000.00\"),3,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),\nCHOOSE(MID(TEXT(B6,\"000000000.00\"),3,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))\n&IF((--LEFT(TEXT(B6,\"000000000.00\"))+MID(TEXT(B6,\"000000000.00\"),2,1)+MID(TEXT(B6,\"000000000.00\"),3,1))=0,,IF(AND((--MID(TEXT(B6,\"000000000.00\"),4,1)+MID(TEXT(B6,\"000000000.00\"),5,1)+MID(TEXT(B6,\"000000000.00\"),6,1)+MID(TEXT(B6,\"000000000.00\"),7,1))=0,(--MID(TEXT(B6,\"000000000.00\"),8,1)+RIGHT(TEXT(B6,\"000000000.00\")))>0),\" Million and \",\" Million \"))\n&CHOOSE(MID(TEXT(B6,\"000000000.00\"),4,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B6,\"000000000.00\"),4,1)=0,,IF(AND(--MID(TEXT(B6,\"000000000.00\"),5,1)=0,--MID(TEXT(B6,\"000000000.00\"),6,1)=0),\" Hundred\",\" Hundred and\"))\n&CHOOSE(MID(TEXT(B6,\"000000000.00\"),5,1)+1,,,\" Twenty\",\" Thirty\",\" Forty\",\" Fifty\",\" Sixty\",\" Seventy\",\" Eighty\",\" Ninety\")\n&IF(--MID(TEXT(B6,\"000000000.00\"),5,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000.00\"),6,1)+1,,\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\"),CHOOSE(MID(TEXT(B6,\"000000000.00\"),6,1)+1,\" Ten\",\" Eleven\",\" Twelve\",\" Thirteen\",\" Fourteen\",\" Fifteen\",\" Sixteen\",\" Seventeen\",\" Eighteen\",\" Nineteen\"))\n&IF((--MID(TEXT(B6,\"000000000.00\"),4,1)+MID(TEXT(B6,\"000000000.00\"),5,1)+MID(TEXT(B6,\"000000000.00\"),6,1))=0,,IF(OR((--MID(TEXT(B6,\"000000000.00\"),7,1)+MID(TEXT(B6,\"000000000.00\"),8,1)+MID(TEXT(B6,\"000000000.00\"),9,1))=0,--MID(TEXT(B6,\"000000000.00\"),7,1)<>0),\" Thousand \",\" Thousand and \"))\n&CHOOSE(MID(TEXT(B6,\"000000000.00\"),7,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B6,\"000000000.00\"),7,1)=0,,IF(AND(--MID(TEXT(B6,\"000000000.00\"),8,1)=0,--MID(TEXT(B6,\"000000000.00\"),9,1)=0),\" Hundred \",\" Hundred and \"))&\nCHOOSE(MID(TEXT(B6,\"000000000.00\"),8,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B6,\"000000000.00\"),8,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000.00\"),9,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),CHOOSE(MID(TEXT(B6,\"000000000.00\"),9,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))","v":" Twenty Three Thousand Four Hundred and Fifty Six"},null,null,null,null,null,null,23456]
[null,34567," Thirty Four Thousand Five Hundred and Sixty Seven",null,null,null,null,null,null,34567]
[null,45678," Forty Five Thousand Six Hundred and Seventy Eight",null,null,null,null,null,null,45678]
[null,56789," Fifty Six Thousand Seven Hundred and Eighty Nine",null,null,null,null,null,null,56789]

{"sheet":"2. VLOOKUP","index":1,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of VLOOKUP Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Numbers","Numbers in Words",null,null,null,null,null,null,"Numbers","Numbers in Words"]
[null,12345,"Twelve Thousand Three Hundred and Forty Five",null,null,null,null,null,null,12345]
[null,23456,"Twenty Three Thousand Four Hundred and Fifty Six",null,null,null,null,null,null,23456]
[null,34567,"Thirty Four Thousand Five Hundred and Sixty Seven",null,null,null,null,null,null,34567]
[null,45678,"Forty Five Thousand Six Hundred and Seventy Eight",null,null,null,null,null,null,45678]
[null,56789,"Fifty Six Thousand Seven Hundred and Eighty Nine",null,null,null,null,null,null,56789]
[]
[null,"Number","Numbers in Words",null,null,null,null,null,null,"Number","Numbers in Words"]
[null,45678,{"$f":"VLOOKUP(B12,B4:C9,2,FALSE)","v":"Forty Five Thousand Six Hundred and Seventy Eight"},null,null,null,null,null,null,45678]

{"sheet":"3. VBA Macro Method - Numeric","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Employing a VBA Macro",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Numbers","Numbers in Words",null,null,null,null,null,null,"Numbers","Numbers in Words"]
[null,12345,{"$f":"number_converting_into_words(B5)","v":" Twelve Thousand Three Hundred and Forty Five "},null,null,null,null,null,null,12345]
[null,23456,{"$f":"number_converting_into_words(B6)","v":" Twenty Three Thousand Four Hundred and Fifty Six "},null,null,null,null,null,null,23456]
[null,34567,{"$f":"number_converting_into_words(B7)","v":" Thirty Four Thousand Five Hundred and Sixty Seven "},null,null,null,null,null,null,34567]
[null,45678,{"$f":"number_converting_into_words(B8)","v":" Forty Five Thousand Six Hundred and Seventy Eight "},null,null,null,null,null,null,45678]
[null,56789,{"$f":"number_converting_into_words(B9)","v":" Fifty Six Thousand Seven Hundred and Eighty Nine "},null,null,null,null,null,null,56789]

{"sheet":"4. VBA Macro Method - Monetary","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using a VBA Macro for Wording Currencies",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Prices ($)","Numbers in Words",null,null,null,null,null,null,"Numbers","Numbers in Words"]
[null,500,{"$f":"Convert_Number_into_word_with_currency(B5)","v":"Five Hundred  Dollars and Zero Cent"},null,null,null,null,null,null,12345]
[null,375.65,{"$f":"Convert_Number_into_word_with_currency(B6)","v":"Three Hundred Seventy Five Dollars and Sixty Five Cents"},null,null,null,null,null,null,23456]
[null,950.7,{"$f":"Convert_Number_into_word_with_currency(B7)","v":"Nine Hundred Fifty  Dollars and Seventy  Cents"},null,null,null,null,null,null,34567]
[null,40,{"$f":"Convert_Number_into_word_with_currency(B8)","v":"Forty  Dollars and Zero Cent"},null,null,null,null,null,null,45678]
[null,750.96,{"$f":"Convert_Number_into_word_with_currency(B9)","v":"Seven Hundred Fifty  Dollars and Ninety Six Cents"},null,null,null,null,null,null,56789]

{"sheet":"1. TEXT Function Method","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using TEXT Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Numbers","Numbers as Text",null,null,null,null,null,null,"Numbers","Numbers as Text"]
[null,12345,{"$f":"TEXT(B5,\"0\")","v":"12345"},null,null,null,null,null,null,12345]
[null,23456,{"$f":"TEXT(B6,\"0\")","v":"23456"},null,null,null,null,null,null,23456]
[null,34567,"34567",null,null,null,null,null,null,34567]
[null,45678,"45678",null,null,null,null,null,null,45678]
[null,56789,"56789",null,null,null,null,null,null,56789]

{"sheet":"2. Format Cell Method","index":5,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of Format Cells Feature",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Numbers","Numbers as Text",null,null,null,null,null,null,"Numbers","Numbers as Text"]
[null,12345,12345,null,null,null,null,null,null,12345]
[null,23456,23456,null,null,null,null,null,null,23456]
[null,34567,34567,null,null,null,null,null,null,34567]
[null,45678,45678,null,null,null,null,null,null,45678]
[null,56789,56789,null,null,null,null,null,null,56789]

{"sheet":"3. The Apostrophe (') method","index":6,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Applying Apostrophe (') Operator",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Numbers","Numbers as Text",null,null,null,null,null,null,"Numbers","Numbers as Text"]
[null,12345,"12345",null,null,null,null,null,null,12345]
[null,23456,"23456",null,null,null,null,null,null,23456]
[null,34567,"34567",null,null,null,null,null,null,34567]
[null,45678,"45678",null,null,null,null,null,null,45678]
[null,56789,"56789",null,null,null,null,null,null,56789]