{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Apostrophe","Format Cell","Number Command","TEXT Function","RIGHT Function","REPT & LEN","CONCATENATE Function","BASE Function","Power Query","Table1","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Apostrophe","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Apostrophe (')",null,null,null,null,"For Practice"]
[]
[null,"Actual Value","Value with \nLeading Zeros",null,null,null,"Actual Value","Value with \nLeading Zeros"]
[null,11,"000011",null,null,null,11]
[null,101,"0000101",null,null,null,101]
[null,222,"0000102",null,null,null,222]
[null,"AB01","00AB01",null,null,null,"AB01"]
[null,"AA","00AB02",null,null,null,"AA"]
[null,"BB","00AB03",null,null,null,"BB"]

{"sheet":"Format Cell","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Format Cell",null,null,null,null,"For Practice"]
[]
[null,"Actual Value","Value with \nLeading Zeros",null,null,null,"Actual Value","Value with \nLeading Zeros"]
[null,11,11,null,null,null,11]
[null,101,101,null,null,null,101]
[null,222,222,null,null,null,222]
[null,"AB01","00AB01",null,null,null,"AB01"]
[null,"AA","00AA",null,null,null,"AA"]
[null,"BB","00BB",null,null,null,"BB"]

{"sheet":"Number Command","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Number Command",null,null,null,null,"For Practice"]
[]
[null,"Actual Value","Value with \nLeading Zeros",null,null,null,"Actual Value","Value with \nLeading Zeros"]
[null,11,"0011",null,null,null,11]
[null,101,"00101",null,null,null,101]
[null,222,"00222",null,null,null,222]
[null,"AB01","00AB01",null,null,null,"AB01"]
[null,"AA","00AA",null,null,null,"AA"]
[null,"BB","00BB",null,null,null,"BB"]

{"sheet":"TEXT Function","index":3,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of TEXT Function",null,null,null,null,"For Practice"]
[]
[null,"Actual Value","Value with \nLeading Zeros",null,null,null,"Actual Value","Value with \nLeading Zeros"]
[null,11,{"$f":"TEXT(B5,\"00000#\")","v":"000011"},null,null,null,11]
[null,101,{"$f":"TEXT(B6,\"00000#\")","v":"000101"},null,null,null,101]
[null,222,"000222",null,null,null,222]

{"sheet":"RIGHT Function","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of RIGHT Function",null,null,null,null,"For Practice"]
[]
[null,"Actual Value","Value with \nLeading Zeros",null,null,null,"Actual Value","Value with \nLeading Zeros"]
[null,11,{"$f":"RIGHT(\"000000\"&B5, 6)","v":"000011"},null,null,null,11]
[null,101,{"$f":"RIGHT(\"000000\"&B6, 6)","v":"000101"},null,null,null,101]
[null,222,"000222",null,null,null,222]
[null,"AB01","00AB01",null,null,null,"AB01"]
[null,"AA","0000AA",null,null,null,"AA"]
[null,"BB","0000BB",null,null,null,"BB"]

{"sheet":"REPT & LEN","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of REPT & LEN Functions",null,null,null,null,"For Practice"]
[]
[null,"Actual Value","Value with \nLeading Zeros",null,null,null,"Actual Value","Value with \nLeading Zeros"]
[null,11,{"$f":"REPT(0,5-LEN(B5))&B5","v":"00011"},null,null,null,11]
[null,101,{"$f":"REPT(0,5-LEN(B6))&B6","v":"00101"},null,null,null,101]
[null,222,"00222",null,null,null,222]
[null,"AB01","0AB01",null,null,null,"AB01"]
[null,"AA","000AA",null,null,null,"AA"]
[null,"BB","000BB",null,null,null,"BB"]

{"sheet":"CONCATENATE Function","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of CONCATENATE Function",null,null,null,null,"For Practice"]
[]
[null,"Actual Value","Value with \nLeading Zeros",null,null,null,"Actual Value","Value with \nLeading Zeros"]
[null,11,{"$f":"CONCATENATE(0,B5)","v":"011"},null,null,null,11]
[null,101,{"$f":"CONCATENATE(0,B6)","v":"0101"},null,null,null,101]
[null,222,"0222",null,null,null,222]
[null,"AB01","0AB01",null,null,null,"AB01"]
[null,"AA","0AA",null,null,null,"AA"]
[null,"BB","0BB",null,null,null,"BB"]

{"sheet":"BASE Function","index":7,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of BASE Function",null,null,null,null,"For Practice"]
[]
[null,"Actual Value","Value with \nLeading Zeros",null,null,null,"Actual Value","Value with \nLeading Zeros"]
[null,11,{"$f":"_xlfn.BASE(B5,10,6)","v":"000011"},null,null,null,11]
[null,101,{"$f":"_xlfn.BASE(B6,10,6)","v":"000101"},null,null,null,101]
[null,222,"000222",null,null,null,222]

{"sheet":"Power Query","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Power Query",null,null,"For Practice"]
[]
[null,"Actual Value",null,null,11]
[null,11,null,null,101]
[null,101,null,null,222]
[null,222,null,null,"AB01"]
[null,"AB01",null,null,"AA"]
[null,"AA",null,null,"BB"]
[null,"BB"]

{"sheet":"Table1","index":9,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Actual Value","Value with Leading Zeros"]
["11","000011"]
["101","000101"]
["222","000222"]
["AB01","00AB01"]
["AA","0000AA"]
["BB","0000BB"]

{"sheet":"VBA","index":10,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of VBA",null,null,null,null,"For Practice"]
[]
[null,"Actual Value","Value with \nLeading Zeros",null,null,null,"Actual Value","Value with \nLeading Zeros"]
[null,11,"00011",null,null,null,11]
[null,101,"00101",null,null,null,101]
[null,222,"00222",null,null,null,222]