{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sheet3","Multiplying by 1","Text to columns","Paste Special Command","VBA","VALUE()","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":"Sheet3","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Numbers with Leading Zeros\n(In Text Format)","VALUE()"]
[879,{"$f":"VALUE(A2)","v":879}]
[1245,{"$f":"VALUE(A3)","v":1245}]
[980,980]
[879,879]
[1245,1245]
[980,980]
[879,879]
[1245,1245]
[980,980]
[879,879]

{"sheet":"Multiplying by 1","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Numbers with Leading Zeros\n(In Text Format)","Factor","Results (Still in Text Format)"]
["000879",1,{"$f":"A2*B2","v":879}]
["001245",1,{"$f":"A3*B3","v":1245}]
["00000980",1,980]
["00012879",1,12879]
["01245",1,1245]
["000980",1,980]
["0000000879",1,879]
["00001245",1,1245]
["00980",1,980]
["00879",1,879]

{"sheet":"Text to columns","index":2,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Numbers with Leading Zeros\n(In Text Format)","TEXT & VALUE Combo"]
["000879",{"$f":"TEXT(VALUE(A2), \"#\")","v":"879"}]
["001245",{"$f":"TEXT(VALUE(A3), \"#\")","v":"1245"}]
["00000980","980"]
["00012879","12879"]
["01245","1245"]
["000980","980"]
["0000000879","879"]
["00001245","1245"]
["00980","980"]
["00879","879"]

{"sheet":"Paste Special Command","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Numbers with Leading Zeros\n(In Text Format)"]
[879,null,1]
[1245]
[980]
[12879]
[1245]
[980]
[879]
[1245]
[980]
[879]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Numbers with Leading Zeros\n(In Text Format)"]
[879]
[1245]
[980]
[25]
[879]
[1245]
[980]
[25]
[879]
[1245]

{"sheet":"VALUE()","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"VALUE(text)"]
[null,"Converts a text string that represents a number to a number."]
[]
[]
[]
[]
[]
[null,"Numbers formatted as Text","Result"]
[null,"$1000",{"$f":"VALUE(B10)","v":1000}]
[null,"123 Apples",{"$f":"VALUE(B11)","v":{"$error":"#VALUE!"}},"<--Shows error as '123 Apples' is not number"]
[null,"0001253",1253]
[null,"16:48:00",0.70000000000000007]
[null,"3/6/2018",43165]

{"sheet":"Non numeric values","index":6,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Text","No leading zeros"]
["000000123",{"$f":"IF(LEFT(A2) = \"0\", RIGHT(A2, LEN(A2)-1), A2)","v":"00000123"},{"$f":"IF(LEFT(B2) = \"0\", RIGHT(B2, LEN(B2)-1), B2)","v":"0000123"},"000123","00123","0123","123","123","123","123"]
["000001DA2 ",{"$f":"IF(LEFT(A3) = \"0\", RIGHT(A3, LEN(A3)-1), A3)","v":"00001DA2 "},"0001DA2 ","001DA2 ","01DA2 ","1DA2 ","1DA2 ","1DA2 ","1DA2 ","1DA2 "]
["0000009Q5",{"$f":"IF(LEFT(A4) = \"0\", RIGHT(A4, LEN(A4)-1), A4)","v":"000009Q5"},"00009Q5","0009Q5","009Q5","09Q5","9Q5","9Q5","9Q5","9Q5"]
["0000L210A",{"$f":"IF(LEFT(A5) = \"0\", RIGHT(A5, LEN(A5)-1), A5)","v":"000L210A"},"00L210A","0L210A","L210A","L210A","L210A","L210A","L210A","L210A"]
["0000014A0",{"$f":"IF(LEFT(A6) = \"0\", RIGHT(A6, LEN(A6)-1), A6)","v":"000014A0"},"00014A0","0014A0","014A0","14A0","14A0","14A0","14A0","14A0"]
["0000A5500",{"$f":"IF(LEFT(A7) = \"0\", RIGHT(A7, LEN(A7)-1), A7)","v":"000A5500"},"00A5500","0A5500","A5500","A5500","A5500","A5500","A5500","A5500"]
["00K002200",{"$f":"IF(LEFT(A8) = \"0\", RIGHT(A8, LEN(A8)-1), A8)","v":"0K002200"},"K002200","K002200","K002200","K002200","K002200","K002200","K002200","K002200"]
[]
["All these texts have 9 characters and we want to remove only the leading zeros."]