{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Converting Text to Number","Changing Custom Number Formatti","Using VALUE Function","Combining VALUE and TEXT Functi","Multiplying by 1","Paste Special Command","Use of Text to Columns Feature","VBA (2)","VBA","Non numeric values"],"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":"Converting Text to Number","index":0,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,14,1,15]]}
[]
[null,"Converting Text to Number",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Final Values",null,null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,879,null,null,null,null,null,null,null,null,null,null,null,null,"00098"]
[null,1245,null,null,null,null,null,null,null,null,null,null,null,null,"003245"]
[null,980,null,null,null,null,null,null,null,null,null,null,null,null,"00000680"]
[null,12879,null,null,null,null,null,null,null,null,null,null,null,null,"0004879"]
[null,1245,null,null,null,null,null,null,null,null,null,null,null,null,"07245"]
[null,980,null,null,null,null,null,null,null,null,null,null,null,null,"000380"]

{"sheet":"Changing Custom Number Formatti","index":1,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of Custom Number Formatting",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Numbers with Leading Zeros","Values",null,null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,"000879",879,null,null,null,null,null,null,null,null,null,null,null,null,"00098"]
[null,"001245",1245,null,null,null,null,null,null,null,null,null,null,null,null,"003245"]
[null,"00000980",980,null,null,null,null,null,null,null,null,null,null,null,null,"00000680"]
[null,"00012879",12879,null,null,null,null,null,null,null,null,null,null,null,null,"0004879"]
[null,"01245",1245,null,null,null,null,null,null,null,null,null,null,null,null,"07245"]
[null,"000980",980,null,null,null,null,null,null,null,null,null,null,null,null,"000380"]

{"sheet":"Using VALUE Function","index":2,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Using VALUE Function",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Numbers with Leading Zeros","Values",null,null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,"000879",{"$f":"VALUE(B5)","v":879},null,null,null,null,null,null,null,null,null,null,null,null,"00098"]
[null,"001245",{"$f":"VALUE(B6)","v":1245},null,null,null,null,null,null,null,null,null,null,null,null,"003245"]
[null,"00000980",980,null,null,null,null,null,null,null,null,null,null,null,null,"00000680"]
[null,"00012879",12879,null,null,null,null,null,null,null,null,null,null,null,null,"0004879"]
[null,"01245",1245,null,null,null,null,null,null,null,null,null,null,null,null,"07245"]
[null,"000980",980,null,null,null,null,null,null,null,null,null,null,null,null,"000380"]

{"sheet":"Combining VALUE and TEXT Functi","index":3,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Combining VALUE and TEXT Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Numbers with Leading Zeros","Values",null,null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,"000879",{"$f":"TEXT(VALUE(B5), \"#\")","v":"879"},null,null,null,null,null,null,null,null,null,null,null,null,"00098"]
[null,"001245",{"$f":"TEXT(VALUE(B6), \"#\")","v":"1245"},null,null,null,null,null,null,null,null,null,null,null,null,"003245"]
[null,"00000980","980",null,null,null,null,null,null,null,null,null,null,null,null,"00000680"]
[null,"00012879","12879",null,null,null,null,null,null,null,null,null,null,null,null,"0004879"]
[null,"01245","1245",null,null,null,null,null,null,null,null,null,null,null,null,"07245"]
[null,"000980","980",null,null,null,null,null,null,null,null,null,null,null,null,"000380"]

{"sheet":"Multiplying by 1","index":4,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,15,1,16]]}
[]
[null,"Multiplying Column with 1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Numbers with Leading Zeros","Factor","Values",null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,"000879",1,{"$f":"B5*C5","v":879},null,null,null,null,null,null,null,null,null,null,null,"00098"]
[null,"001245",1,{"$f":"B6*C6","v":1245},null,null,null,null,null,null,null,null,null,null,null,"003245"]
[null,"00000980",1,980,null,null,null,null,null,null,null,null,null,null,null,"00000680"]
[null,"00012879",1,12879,null,null,null,null,null,null,null,null,null,null,null,"0004879"]
[null,"01245",1,1245,null,null,null,null,null,null,null,null,null,null,null,"07245"]
[null,"000980",1,980,null,null,null,null,null,null,null,null,null,null,null,"000380"]

{"sheet":"Paste Special Command","index":5,"n_rows":10,"n_cols":18,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,16,1,17],[1,1,1,2]]}
[]
[null,"Using Paste Special Command",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Numbers with Leading Zeros",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,879,1,null,null,null,null,null,null,null,null,null,null,null,null,null,"00098"]
[null,1245,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"003245"]
[null,980,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00000680"]
[null,12879,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0004879"]
[null,1245,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07245"]
[null,980,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"000380"]

{"sheet":"Use of Text to Columns Feature","index":6,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of Text to Columns Feature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Numbers with Leading Zeros","Values",null,null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,"000879",879,null,null,null,null,null,null,null,null,null,null,null,null,"00098"]
[null,"001245",1245,null,null,null,null,null,null,null,null,null,null,null,null,"003245"]
[null,"00000980",980,null,null,null,null,null,null,null,null,null,null,null,null,"00000680"]
[null,"00012879",12879,null,null,null,null,null,null,null,null,null,null,null,null,"0004879"]
[null,"01245",1245,null,null,null,null,null,null,null,null,null,null,null,null,"07245"]
[null,"000980",980,null,null,null,null,null,null,null,null,null,null,null,null,"000380"]

{"sheet":"VBA (2)","index":7,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,15,1,16]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Numbers with Leading Zeros",null,null,null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,"000879",null,null,null,null,null,null,null,null,null,null,null,null,null,98]
[null,"001245",null,null,null,null,null,null,null,null,null,null,null,null,null,3245]
[null,"00000980",null,null,null,null,null,null,null,null,null,null,null,null,null,680]
[null,"00012879",null,null,null,null,null,null,null,null,null,null,null,null,null,4879]
[null,"01245",null,null,null,null,null,null,null,null,null,null,null,null,null,7245]
[null,"000980",null,null,null,null,null,null,null,null,null,null,null,null,null,380]
[null,"0000000879"]

{"sheet":"VBA","index":8,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,15,1,16]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Numbers with Leading Zeros",null,null,null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,879,null,null,null,null,null,null,null,null,null,null,null,null,null,98]
[null,1245,null,null,null,null,null,null,null,null,null,null,null,null,null,3245]
[null,980,null,null,null,null,null,null,null,null,null,null,null,null,null,680]
[null,12879,null,null,null,null,null,null,null,null,null,null,null,null,null,4879]
[null,1245,null,null,null,null,null,null,null,null,null,null,null,null,null,7245]
[null,980,null,null,null,null,null,null,null,null,null,null,null,null,null,380]
[null,879]

{"sheet":"Non numeric values","index":9,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,15,1,16]]}
[]
[null,"Removing Leading Zeros from Non-numeric Values",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Text","Reducing leading zeros","No leading zeros",null,null,null,null,null,null,null,null,null,null,null,"Numbers with Leading Zeros","Values"]
[null,"00123",{"$f":"IF(LEFT(B5) = \"0\", RIGHT(B5, LEN(B5)-1), B5)","v":"0123"},{"$f":"IF(LEFT(C5) = \"0\", RIGHT(C5, LEN(C5)-1), C5)","v":"123"},null,null,null,null,null,null,null,null,null,null,null,"00098"]
[null,"001DA2 ",{"$f":"IF(LEFT(B6) = \"0\", RIGHT(B6, LEN(B6)-1), B6)","v":"01DA2 "},"1DA2 ",null,null,null,null,null,null,null,null,null,null,null,"003245"]
[null,"009Q5",{"$f":"IF(LEFT(B7) = \"0\", RIGHT(B7, LEN(B7)-1), B7)","v":"09Q5"},"9Q5",null,null,null,null,null,null,null,null,null,null,null,"00000680"]
[null,"00L210A",{"$f":"IF(LEFT(B8) = \"0\", RIGHT(B8, LEN(B8)-1), B8)","v":"0L210A"},"L210A",null,null,null,null,null,null,null,null,null,null,null,"0004879"]
[null,"0014A0",{"$f":"IF(LEFT(B9) = \"0\", RIGHT(B9, LEN(B9)-1), B9)","v":"014A0"},"14A0",null,null,null,null,null,null,null,null,null,null,null,"07245"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"000380"]