{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","TEXT Function","Overview","Apostrophe","Format Cells","Text to Columns","VBA","VLOOKUP","Practice Section"],"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":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sample Dataset"]
[]
[null,"Order Date","Region","Rep","Telephone","Total Sales"]
[null,"2023-03-15","West","Sorvino",15551234567,60.42]
[null,"2023-04-01","East","Jones",44201234567,177]
[null,"2023-04-18","Central","Andrews",61298765432,140.26999999999998]
[null,"2022-06-25","Central","Morgan",23456789,64.800000000000011]
[null,"2022-07-12","East","Howard",123456789,106]
[null,"2022-07-29","East","Parent",987654328,235.06]
[null,"2022-08-15","East","Jones",7612345678,72.8]
[null,"2022-09-01","Central","Smith",398765432,168.70000000000002]
[null,"2022-09-18","East","Jones",1212345678,57.599999999999994]
[null,"2022-10-05","Central","Morgan",2341234567,350]

{"sheet":"TEXT Function","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using TEXT Function to Convert Number to Text"]
[]
[null,"Number Format","Converted to Text Format","Used Formula","Remarks"]
[null,98765432,{"$f":"TEXT(B5,0)","v":"98765432"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TEXT(B5,0)"},"Returns only integer number"]
[null,15551234.567,{"$f":"TEXT(B6,\"0\")","v":"15551235"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=TEXT(B6,\"0\")"},"Returns only integer number"]
[null,12345,{"$f":"TEXT(B7,\"000000\")","v":"012345"},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=TEXT(B7,\"000000\")"},"Returns 6 digits integer number"]
[null,98765,{"$f":"TEXT(B8,\"0000000\")","v":"0098765"},"=TEXT(B8,\"0000000\")","Returns 7 digits integer number"]
[null,12345.67,{"$f":"TEXT(B9,\"0.0\")","v":"12345.7"},"=TEXT(B9,\"0.0\")","Considers one decimal place"]
[null,6129876.5432000002,{"$f":"TEXT(B10,\"0.00\")","v":"6129876.54"},"=TEXT(B10,\"0.00\")","Considers two decimal places"]
[null,23456.78,{"$f":"TEXT(B11,\"0.000\")","v":"23456.780"},"=TEXT(B11,\"0.000\")","Considers three decimal places"]
[null,612345678,{"$f":"TEXT(B12,\"$#,###\")","v":"$612,345,678"},"=TEXT(B12,\"$#,###\")","Returns currency format"]
[null,442012345678,{"$f":"TEXT(B13,\"General\")","v":"4.42012E+11"},"=TEXT(B13,\"General\")","Considers scientific notation"]
[null,44805,{"$f":"TEXT(B14,\"YYYY-MM-DD\")","v":"2022-09-01"},{"$f":"_xlfn.FORMULATEXT(C14)","v":"=TEXT(B14,\"YYYY-MM-DD\")"},"Returns date format"]

{"sheet":"Overview","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Converting Number to Text"]
[]
[null,"Number Format","Converted to Text Format","Used Formula","Remarks"]
[null,98765432,{"$f":"TEXT(B5,0)","v":"98765432"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TEXT(B5,0)"},"Returns only integer number"]
[null,15551234.567,{"$f":"TEXT(B6,\"0\")","v":"15551235"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=TEXT(B6,\"0\")"},"Returns only integer number"]
[null,12345,{"$f":"TEXT(B7,\"000000\")","v":"012345"},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=TEXT(B7,\"000000\")"},"Returns 6 digits integer number"]
[null,98765,{"$f":"TEXT(B8,\"0000000\")","v":"0098765"},"=TEXT(B8,\"0000000\")","Returns 7 digits integer number"]
[null,12345.67,{"$f":"TEXT(B9,\"0.0\")","v":"12345.7"},"=TEXT(B9,\"0.0\")","Considers one decimal place"]
[null,6129876.5432000002,{"$f":"TEXT(B10,\"0.00\")","v":"6129876.54"},"=TEXT(B10,\"0.00\")","Considers two decimal places"]
[null,23456.78,{"$f":"TEXT(B11,\"0.000\")","v":"23456.780"},"=TEXT(B11,\"0.000\")","Considers three decimal places"]
[null,612345678,{"$f":"TEXT(B12,\"$#,###\")","v":"$612,345,678"},"=TEXT(B12,\"$#,###\")","Returns currency format"]
[null,442012345678,{"$f":"TEXT(B13,\"General\")","v":"4.42012E+11"},"=TEXT(B13,\"General\")","Considers scientific notation"]
[null,44805,{"$f":"TEXT(B14,\"YYYY-MM-DD\")","v":"2022-09-01"},{"$f":"_xlfn.FORMULATEXT(C14)","v":"=TEXT(B14,\"YYYY-MM-DD\")"},"Returns date format"]

{"sheet":"Apostrophe","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Converting Number to Text with Apostrophe"]
[]
[null,"Order Date","Rep","Telephone","Text Format"]
[null,"2023-03-15","Sorvino",15551234567,"15551234567"]
[null,"2023-04-01","Jones",44201234567,"44201234567"]
[null,"2023-04-18","Andrews",61298765432,"61298765432"]
[null,"2022-06-25","Morgan",23456789,"00023456789"]
[null,"2022-07-12","Howard",123456789,"00123456789"]
[null,"2022-07-29","Parent",987654328,"00987654328"]
[null,"2022-08-15","Jones",7612345678,"07612345678"]
[null,"2022-09-01","Smith",398765432,"00398765432"]
[null,"2022-09-18","Jones",1212345678,"01212345678"]
[null,"2022-10-05","Morgan",2341234567,"02341234567"]

{"sheet":"Format Cells","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Format Cells Feature to Convert Number to Text"]
[]
[null,"Order Date","Region","Rep","Telephone"]
[null,"2023-03-15","West","Sorvino","15551234567"]
[null,"2023-04-01","East","Jones","44201234567"]
[null,"2023-04-18","Central","Andrews","61298765432"]
[null,"2022-06-25","Central","Morgan","00023456789"]
[null,"2022-07-12","East","Howard","00123456789"]
[null,"2022-07-29","East","Parent","00987654328"]
[null,"2022-08-15","East","Jones","07612345678"]
[null,"2022-09-01","Central","Smith","00398765432"]
[null,"2022-09-18","East","Jones","01212345678"]
[null,"2022-10-05","Central","Morgan","02341234567"]

{"sheet":"Text to Columns","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Text to Columns Wizard"]
[]
[null,"Order Date","Region","Rep","Telephone"]
[null,"2023-03-15","West","Sorvino","15551234567"]
[null,"2023-04-01","East","Jones","442012345678"]
[null,"2023-04-18","Central","Andrews","61298765432"]
[null,"2022-06-25","Central","Morgan","23456789"]
[null,"2022-07-12","East","Howard","12345678"]
[null,"2022-07-29","East","Parent","98765432"]
[null,"2022-08-15","East","Jones","612345678"]
[null,"2022-09-01","Central","Smith","98765432"]
[null,"2022-09-18","East","Jones","12345678"]
[null,"2022-10-05","Central","Morgan","1234567"]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Converting Number to Words"]
[]
[null,"Rep","Total Sales","Total Sales in Words"]
[null,"Sorvino",60.42,{"$f":"Convert_Number_into_word_with_currency(C5)","v":"Sixty Dollars and Forty TwoCents"}]
[null,"Jones",177,{"$f":"Convert_Number_into_word_with_currency(C6)","v":"One Hundred Seventy SevenDollars and Zero Cent"}]
[null,"Andrews",140.26999999999998,{"$f":"Convert_Number_into_word_with_currency(C7)","v":"One Hundred Forty Dollars and Twenty SevenCents"}]
[null,"Morgan",64.800000000000011,{"$f":"Convert_Number_into_word_with_currency(C8)","v":"Sixty FourDollars and Eighty Cents"}]
[null,"Howard",106,{"$f":"Convert_Number_into_word_with_currency(C9)","v":"One Hundred SixDollars and Zero Cent"}]
[null,"Parent",235.06,{"$f":"Convert_Number_into_word_with_currency(C10)","v":"Two Hundred Thirty FiveDollars and SixCents"}]
[null,"Jones",72.8,{"$f":"Convert_Number_into_word_with_currency(C11)","v":"Seventy TwoDollars and Eighty Cents"}]
[null,"Smith",168.70000000000002,{"$f":"Convert_Number_into_word_with_currency(C12)","v":"One Hundred Sixty EightDollars and Seventy Cents"}]
[null,"Jones",57.599999999999994,{"$f":"Convert_Number_into_word_with_currency(C13)","v":"Fifty SevenDollars and Sixty Cents"}]
[null,"Morgan",350,{"$f":"Convert_Number_into_word_with_currency(C14)","v":"Three Hundred Fifty Dollars and Zero Cent"}]

{"sheet":"VLOOKUP","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Converting Number to Text for VLOOKUP Function"]
[]
[null,"ID","Region","Rep","Order Date"]
[null,"15551234567","West","Sorvino","2023-03-15"]
[null,"44201234567","East","Jones","2023-04-01"]
[null,"61298765432","Central","Andrews","2023-04-18"]
[null,"00023456789","Central","Morgan","2022-06-25"]
[null,"00123456789","East","Howard","2022-07-12"]
[null,"00987654328","East","Parent","2022-07-29"]
[null,"07612345678","East","Jones","2022-08-15"]
[null,"00398765432","Central","Smith","2022-09-01"]
[null,"01212345678","East","Jones","2022-09-18"]
[null,"02341234567","Central","Morgan","2022-10-05"]
[]
[null,null,null,"ID","Rep"]
[null,null,null,15551234567,{"$f":"VLOOKUP(TEXT(D17,0),B5:E14,3,FALSE)","v":"Sorvino"}]

{"sheet":"Practice Section","index":8,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Do It Yourself"]
[]
[null,"Number Format","Converted to Text Format"]
[null,98765432]
[null,15551234.567]
[null,12345]
[null,98765]
[null,12345.67]
[null,6129876.5432000002]
[null,23456.78]
[null,612345678]
[null,442012345678]
[null,44805]