{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Customize Number","Special Cell Format ","Using Text Format","TEXT Function","Apostrophe","Right + &","BASE Function","Power Query Editor","Data","REPT & LEN Functions","Adding Fixed Zeros","VBA","pivot table","dataset"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":"Customize Number","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Number Formatting",null,null,null,null,null,null,"For Practice"]
[]
[null,"States","Zip Codes",null,null,null,null,null,"States","Zip Codes"]
[null,"Connecticut",6103,null,null,null,null,null,"Connecticut",6103]
[null,"Florida ",32301,null,null,null,null,null,"Florida ",32301]
[null,"Maine",4330,null,null,null,null,null,"Maine",4330]
[null,"Massachusetts",2201,null,null,null,null,null,"Massachusetts",2201]
[null,"New Hampshire",3301,null,null,null,null,null,"New Hampshire",3301]
[null,"Texas",78701,null,null,null,null,null,"Texas",78701]
[null,"Puerto Rico",901,null,null,null,null,null,"Puerto Rico",901]
[null,"Virgin Islands",802,null,null,null,null,null,"Virgin Islands",802]

{"sheet":"Special Cell Format ","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[7,10,7,13]]}
[]
[null,"Special Formatting",null,null,null,null,null,null,"For Practice"]
[]
[null,"States","Zip Codes",null,null,null,null,null,"States","Zip Codes"]
[null,"Connecticut",6103,null,null,null,null,null,"Connecticut"]
[null,"Florida ",32301,null,null,null,null,null,"Florida "]
[null,"Maine",4330,null,null,null,null,null,"Maine"]
[null,"Massachusetts",2201,null,null,null,null,null,"Massachusetts"]
[null,"New Hampshire",3301,null,null,null,null,null,"New Hampshire"]
[null,"Texas",78701,null,null,null,null,null,"Texas"]
[null,"Puerto Rico",901,null,null,null,null,null,"Puerto Rico"]
[null,"Virgin Islands",802,null,null,null,null,null,"Virgin Islands"]

{"sheet":"Using Text Format","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8],[7,9,7,12]]}
[]
[null,"Text Formatting",null,null,null,null,null,"For Practice"]
[]
[null,"States","Zip Codes",null,null,null,null,"States","Zip Codes"]
[null,"Connecticut","06103",null,null,null,null,"Connecticut"]
[null,"Florida ","32301",null,null,null,null,"Florida "]
[null,"Maine","04330",null,null,null,null,"Maine"]
[null,"Massachusetts","02201",null,null,null,null,"Massachusetts"]
[null,"New Hampshire","03301",null,null,null,null,"New Hampshire"]
[null,"Texas","78701",null,null,null,null,"Texas"]
[null,"Puerto Rico","00901",null,null,null,null,"Puerto Rico"]
[null,"Virgin Islands","00802",null,null,null,null,"Virgin Islands"]

{"sheet":"TEXT Function","index":3,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[7,6,7,7],[1,8,1,10]]}
[]
[null,"Use of TEXT Function",null,null,null,null,null,null,"For Practice"]
[]
[null,"States","Zip Codes\n(Without Formatting)","Zip Codes\n(With Formatting)",null,null,null,null,"States","Zip Codes\n(Without Formatting)","Zip Codes\n(With Formatting)"]
[null,"Connecticut",6103,{"$f":"TEXT(C5,\"00000\")","v":"06103"},null,null,null,null,"Connecticut",6103]
[null,"Florida ",32301,{"$f":"TEXT(C6,\"00000\")","v":"32301"},null,null,null,null,"Florida ",32301]
[null,"Maine",4330,"04330",null,null,null,null,"Maine",4330]
[null,"Massachusetts",2201,"02201",null,null,null,null,"Massachusetts",2201]
[null,"New Hampshire",3301,"03301",null,null,null,null,"New Hampshire",3301]
[null,"Texas",78701,"78701",null,null,null,null,"Texas",78701]
[null,"Puerto Rico",901,"00901",null,null,null,null,"Puerto Rico",901]
[null,"Virgin Islands",802,"00802",null,null,null,null,"Virgin Islands",802]

{"sheet":"Apostrophe","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[7,10,7,13]]}
[]
[null,"Use of Apostrophe(')",null,null,null,null,null,null,"For Practice"]
[]
[null,"States","Zip Codes",null,null,null,null,null,"States","Zip Codes"]
[null,"Connecticut","06103",null,null,null,null,null,"Connecticut","06103"]
[null,"Florida ","32301",null,null,null,null,null,"Florida ","32301"]
[null,"Maine","04330",null,null,null,null,null,"Maine","04330"]
[null,"Massachusetts","02201",null,null,null,null,null,"Massachusetts","02201"]
[null,"New Hampshire","03301",null,null,null,null,null,"New Hampshire","03301"]
[null,"Texas","78701",null,null,null,null,null,"Texas","78701"]
[null,"Puerto Rico","00901",null,null,null,null,null,"Puerto Rico","00901"]
[null,"Virgin Islands","00802",null,null,null,null,null,"Virgin Islands","00802"]

{"sheet":"Right + &","index":5,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Combination of RIGHT and Ampersand",null,null,null,"For Practice"]
[]
[null,"States","Zip Codes\n(Without Formatting)","Zip Codes\n(With Formatting)",null,"States","Zip Codes\n(Without Formatting)","Zip Codes\n(With Formatting)"]
[null,"Connecticut",6103,{"$f":"RIGHT(\"00000\"&C5,5)","v":"06103"},null,"Connecticut",6103]
[null,"Florida ",32301,{"$f":"RIGHT(\"00000\"&C6,5)","v":"32301"},null,"Florida ",32301]
[null,"Maine",4330,"04330",null,"Maine",4330]
[null,"Massachusetts",2201,"02201",null,"Massachusetts",2201]
[null,"New Hampshire",3301,"03301",null,"New Hampshire",3301]
[null,"Texas",78701,"78701",null,"Texas",78701]
[null,"Puerto Rico",901,"00901",null,"Puerto Rico",901]
[null,"Virgin Islands",802,"00802",null,"Virgin Islands",802]

{"sheet":"BASE Function","index":6,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of BASE Function",null,null,null,null,null,"For Practice"]
[]
[null,"States","Zip Codes\n(Without Formatting)","Zip Codes\n(With Formatting)",null,null,null,"States","Zip Codes\n(Without Formatting)","Zip Codes\n(With Formatting)"]
[null,"Connecticut",6103,{"$f":"_xlfn.BASE(C5,10,5)","v":"06103"},null,null,null,"Connecticut",6103]
[null,"Florida ",32301,{"$f":"_xlfn.BASE(C6,10,5)","v":"32301"},null,null,null,"Florida ",32301]
[null,"Maine",4330,"04330",null,null,null,"Maine",4330]
[null,"Massachusetts",2201,"02201",null,null,null,"Massachusetts",2201]
[null,"New Hampshire",3301,"03301",null,null,null,"New Hampshire",3301]
[null,"Texas",78701,"78701",null,null,null,"Texas",78701]
[null,"Puerto Rico",901,"00901",null,null,null,"Puerto Rico",901]
[null,"Virgin Islands",802,"00802",null,null,null,"Virgin Islands",802]

{"sheet":"Power Query Editor","index":7,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Column1","ZIp Codes With Formatting"]
["6103","06103"]
["32301","32301"]
["4330","04330"]
["2201","02201"]
["3301","03301"]
["78701","78701"]
["901","00901"]
["802","00802"]

{"sheet":"Data","index":8,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Column1","Zip Codes with Formatting"]
["6103","06103"]
["32301","32301"]
["4330","04330"]
["2201","02201"]
["3301","03301"]
["78701","78701"]
["901","00901"]
["802","00802"]

{"sheet":"REPT & LEN Functions","index":9,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of REPT & LEN Functions",null,null,null,null,null,"For Practice"]
[]
[null,"States","Zip Codes\n(Without Formatting)","Zip Codes\n(With Formatting)",null,null,null,"States","Zip Codes\n(Without Formatting)","Zip Codes\n(With Formatting)"]
[null,"Connecticut",6103,{"$f":"REPT(0,5-LEN(C5))&C5","v":"06103"},null,null,null,"Connecticut",6103]
[null,"Florida ",32301,{"$f":"REPT(0,5-LEN(C6))&C6","v":"32301"},null,null,null,"Florida ",32301]
[null,"Maine",4330,"04330",null,null,null,"Maine",4330]
[null,"Massachusetts",2201,"02201",null,null,null,"Massachusetts",2201]
[null,"New Hampshire",3301,"03301",null,null,null,"New Hampshire",3301]
[null,"Texas",78701,"78701",null,null,null,"Texas",78701]
[null,"Puerto Rico",901,"00901",null,null,null,"Puerto Rico",901]
[null,"Virgin Islands",802,"00802",null,null,null,"Virgin Islands",802]

{"sheet":"Adding Fixed Zeros","index":10,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[7,10,7,13],[1,5,1,6]]}
[]
[null,"Adding Fixed Number of Leading Zeros",null,null,null,"For Practice"]
[]
[null,"Numbers","Adding Two Leading Zeros",null,null,"Numbers","Adding Two Leading Zeros"]
[null,545,{"$f":"CONCATENATE(\"00\",B5)","v":"00545"},null,null,545]
[null,67,{"$f":"CONCATENATE(\"00\",B6)","v":"0067"},null,null,67]
[null,-39,"00-39",null,null,-39]
[null,1.45,"001.45",null,null,1.45]
[null,-777,"00-777",null,null,-777]
[null,8,"008",null,null,8]
[null,0.05,"000.05",null,null,0.05]
[null,456,"00456",null,null,456]

{"sheet":"VBA","index":11,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[7,10,7,13]]}
[]
[null,"Using  VBA Code",null,null,null,null,null,null,"For Practice"]
[]
[null,"States","Zip Codes",null,null,null,null,null,"States","Zip Codes"]
[null,"Connecticut",6103,null,null,null,null,null,"Connecticut"]
[null,"Florida ",32301,null,null,null,null,null,"Florida "]
[null,"Maine",4330,null,null,null,null,null,"Maine"]
[null,"Massachusetts",2201,null,null,null,null,null,"Massachusetts"]
[null,"New Hampshire",3301,null,null,null,null,null,"New Hampshire"]
[null,"Texas",78701,null,null,null,null,null,"Texas"]
[null,"Puerto Rico",901,null,null,null,null,null,"Puerto Rico"]
[null,"Virgin Islands",802,null,null,null,null,null,"Virgin Islands"]

{"sheet":"pivot table","index":12,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Zip Code with Zip Codes with Leading Zeros"]
["06103,32301,04330,02201,03301,78701,00901,00802"]

{"sheet":"dataset","index":13,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[7,10,7,13]]}
[]
[null,"Use of Pivot Table",null,null,null,null,null,null,"For Practice"]
[]
[null,"States","Zip Codes",null,null,null,null,null,"States","Zip Codes"]
[null,"Connecticut",6103,null,null,null,null,null,"Connecticut",6103]
[null,"Florida ",32301,null,null,null,null,null,"Florida ",32301]
[null,"Maine",4330,null,null,null,null,null,"Maine",4330]
[null,"Massachusetts",2201,null,null,null,null,null,"Massachusetts",2201]
[null,"New Hampshire",3301,null,null,null,null,null,"New Hampshire",3301]
[null,"Texas",78701,null,null,null,null,null,"Texas",78701]
[null,"Puerto Rico",901,null,null,null,null,null,"Puerto Rico",901]
[null,"Virgin Islands",802,null,null,null,null,null,"Virgin Islands",802]