{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["1. TEXT Function Method","2. Format Cell Method","3. The Apostrophe (') method","1. Excel Formula Method","2. VBA Macro Method - Numeric","2. VBA Macro Method - Monetary"],"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. TEXT Function Method","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Converting numbers into text using the TEXT function"]
[]
[null,"Goal=","Convert the numbers in the following Numbers column into text"]
[]
[null,"Numbers","Output"]
[null,12345,{"$f":"TEXT(B7,\"0\")","v":"12345"}]
[null,23456,{"$f":"TEXT(B8,\"0\")","v":"23456"}]
[null,34567,"34567"]
[null,45678,"45678"]
[null,56789,"56789"]

{"sheet":"2. Format Cell Method","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Converting numbers into text using the \"Format Cell\" option"]
[]
[null,"Goal=","Convert the numbers in the following Numbers column into text"]
[]
[null,"Numbers","Output"]
[null,12345,12345]
[null,23456,23456]
[null,34567,34567]
[null,45678,45678]
[null,56789,56789]

{"sheet":"3. The Apostrophe (') method","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Converting numbers into text using the Apostrophe (') method"]
[]
[null,"Goal=","Convert the numbers in the following Numbers column into text"]
[]
[null,"Numbers","Output"]
[null,12345,"12345"]
[null,23456,"23456"]
[null,34567,"34567"]
[null,45678,"45678"]
[null,56789,"56789"]

{"sheet":"1. Excel Formula Method","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Converting numbers into words using an Excel formula"]
[]
[null,"Goal=","Convert the numbers in the following Numbers column into words"]
[]
[null,"Numbers","Output"]
[null,12345,{"$f":"CHOOSE(LEFT(TEXT(B7,\"000000000.00\"))+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--LEFT(TEXT(B7,\"000000000.00\"))=0,,IF(AND(--MID(TEXT(B7,\"000000000.00\"),2,1)=0,--MID(TEXT(B7,\"000000000.00\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&CHOOSE(MID(TEXT(B7,\"000000000.00\"),2,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B7,\"000000000.00\"),2,1)<>1,CHOOSE(MID(TEXT(B7,\"000000000.00\"),3,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),\nCHOOSE(MID(TEXT(B7,\"000000000.00\"),3,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))\n&IF((--LEFT(TEXT(B7,\"000000000.00\"))+MID(TEXT(B7,\"000000000.00\"),2,1)+MID(TEXT(B7,\"000000000.00\"),3,1))=0,,IF(AND((--MID(TEXT(B7,\"000000000.00\"),4,1)+MID(TEXT(B7,\"000000000.00\"),5,1)+MID(TEXT(B7,\"000000000.00\"),6,1)+MID(TEXT(B7,\"000000000.00\"),7,1))=0,(--MID(TEXT(B7,\"000000000.00\"),8,1)+RIGHT(TEXT(B7,\"000000000.00\")))>0),\" Million and \",\" Million \"))\n&CHOOSE(MID(TEXT(B7,\"000000000.00\"),4,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B7,\"000000000.00\"),4,1)=0,,IF(AND(--MID(TEXT(B7,\"000000000.00\"),5,1)=0,--MID(TEXT(B7,\"000000000.00\"),6,1)=0),\" Hundred\",\" Hundred and\"))\n&CHOOSE(MID(TEXT(B7,\"000000000.00\"),5,1)+1,,,\" Twenty\",\" Thirty\",\" Forty\",\" Fifty\",\" Sixty\",\" Seventy\",\" Eighty\",\" Ninety\")\n&IF(--MID(TEXT(B7,\"000000000.00\"),5,1)<>1,CHOOSE(MID(TEXT(B7,\"000000000.00\"),6,1)+1,,\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\"),CHOOSE(MID(TEXT(B7,\"000000000.00\"),6,1)+1,\" Ten\",\" Eleven\",\" Twelve\",\" Thirteen\",\" Fourteen\",\" Fifteen\",\" Sixteen\",\" Seventeen\",\" Eighteen\",\" Nineteen\"))\n&IF((--MID(TEXT(B7,\"000000000.00\"),4,1)+MID(TEXT(B7,\"000000000.00\"),5,1)+MID(TEXT(B7,\"000000000.00\"),6,1))=0,,IF(OR((--MID(TEXT(B7,\"000000000.00\"),7,1)+MID(TEXT(B7,\"000000000.00\"),8,1)+MID(TEXT(B7,\"000000000.00\"),9,1))=0,--MID(TEXT(B7,\"000000000.00\"),7,1)<>0),\" Thousand \",\" Thousand and \"))\n&CHOOSE(MID(TEXT(B7,\"000000000.00\"),7,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B7,\"000000000.00\"),7,1)=0,,IF(AND(--MID(TEXT(B7,\"000000000.00\"),8,1)=0,--MID(TEXT(B7,\"000000000.00\"),9,1)=0),\" Hundred \",\" Hundred and \"))&\nCHOOSE(MID(TEXT(B7,\"000000000.00\"),8,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B7,\"000000000.00\"),8,1)<>1,CHOOSE(MID(TEXT(B7,\"000000000.00\"),9,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),CHOOSE(MID(TEXT(B7,\"000000000.00\"),9,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))","v":" Twelve Thousand Three Hundred and Forty Five"}]
[null,23456,{"$f":"CHOOSE(LEFT(TEXT(B8,\"000000000.00\"))+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--LEFT(TEXT(B8,\"000000000.00\"))=0,,IF(AND(--MID(TEXT(B8,\"000000000.00\"),2,1)=0,--MID(TEXT(B8,\"000000000.00\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&CHOOSE(MID(TEXT(B8,\"000000000.00\"),2,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B8,\"000000000.00\"),2,1)<>1,CHOOSE(MID(TEXT(B8,\"000000000.00\"),3,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),\nCHOOSE(MID(TEXT(B8,\"000000000.00\"),3,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))\n&IF((--LEFT(TEXT(B8,\"000000000.00\"))+MID(TEXT(B8,\"000000000.00\"),2,1)+MID(TEXT(B8,\"000000000.00\"),3,1))=0,,IF(AND((--MID(TEXT(B8,\"000000000.00\"),4,1)+MID(TEXT(B8,\"000000000.00\"),5,1)+MID(TEXT(B8,\"000000000.00\"),6,1)+MID(TEXT(B8,\"000000000.00\"),7,1))=0,(--MID(TEXT(B8,\"000000000.00\"),8,1)+RIGHT(TEXT(B8,\"000000000.00\")))>0),\" Million and \",\" Million \"))\n&CHOOSE(MID(TEXT(B8,\"000000000.00\"),4,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B8,\"000000000.00\"),4,1)=0,,IF(AND(--MID(TEXT(B8,\"000000000.00\"),5,1)=0,--MID(TEXT(B8,\"000000000.00\"),6,1)=0),\" Hundred\",\" Hundred and\"))\n&CHOOSE(MID(TEXT(B8,\"000000000.00\"),5,1)+1,,,\" Twenty\",\" Thirty\",\" Forty\",\" Fifty\",\" Sixty\",\" Seventy\",\" Eighty\",\" Ninety\")\n&IF(--MID(TEXT(B8,\"000000000.00\"),5,1)<>1,CHOOSE(MID(TEXT(B8,\"000000000.00\"),6,1)+1,,\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\"),CHOOSE(MID(TEXT(B8,\"000000000.00\"),6,1)+1,\" Ten\",\" Eleven\",\" Twelve\",\" Thirteen\",\" Fourteen\",\" Fifteen\",\" Sixteen\",\" Seventeen\",\" Eighteen\",\" Nineteen\"))\n&IF((--MID(TEXT(B8,\"000000000.00\"),4,1)+MID(TEXT(B8,\"000000000.00\"),5,1)+MID(TEXT(B8,\"000000000.00\"),6,1))=0,,IF(OR((--MID(TEXT(B8,\"000000000.00\"),7,1)+MID(TEXT(B8,\"000000000.00\"),8,1)+MID(TEXT(B8,\"000000000.00\"),9,1))=0,--MID(TEXT(B8,\"000000000.00\"),7,1)<>0),\" Thousand \",\" Thousand and \"))\n&CHOOSE(MID(TEXT(B8,\"000000000.00\"),7,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B8,\"000000000.00\"),7,1)=0,,IF(AND(--MID(TEXT(B8,\"000000000.00\"),8,1)=0,--MID(TEXT(B8,\"000000000.00\"),9,1)=0),\" Hundred \",\" Hundred and \"))&\nCHOOSE(MID(TEXT(B8,\"000000000.00\"),8,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B8,\"000000000.00\"),8,1)<>1,CHOOSE(MID(TEXT(B8,\"000000000.00\"),9,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),CHOOSE(MID(TEXT(B8,\"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,34567," Thirty Four Thousand Five Hundred and Sixty Seven"]
[null,45678," Forty Five Thousand Six Hundred and Seventy Eight"]
[null,56789," Fifty Six Thousand Seven Hundred and Eighty Nine"]

{"sheet":"2. VBA Macro Method - Numeric","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Converting numbers into words using a VBA macro"]
[]
[null,"Goal=","Convert the numbers in the following Numbers column into words"]
[]
[null,"Numbers","Output"]
[null,12345,{"$f":"NumberstoWords(B7)","v":" Twelve Thousand Three Hundred and Forty Five "}]
[null,23456,{"$f":"NumberstoWords(B8)","v":" Twenty Three Thousand Four Hundred and Fifty Six "}]
[null,34567," Thirty Four Thousand Five Hundred and Sixty Seven "]
[null,45678," Forty Five Thousand Six Hundred and Seventy Eight "]
[null,56789," Fifty Six Thousand Seven Hundred and Eighty Nine "]

{"sheet":"2. VBA Macro Method - Monetary","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Converting numbers into words using a VBA macro"]
[]
[null,"Goal=","Convert the numbers in the following Prices into words"]
[]
[null,"Prices ($)","Output"]
[null,500,{"$f":"SpellNumberToEnglish(B7)","v":"Five Hundred  Dollars and No Cents"}]
[null,375.65,{"$f":"SpellNumberToEnglish(B8)","v":"Three Hundred Seventy Five Dollars and Sixty Five Cents"}]
[null,950.7,"Nine Hundred Fifty  Dollars and Seventy  Cents"]
[null,40,"Forty  Dollars and No Cents"]
[null,750.96,"Seven Hundred Fifty  Dollars and Ninety Six Cents"]