{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sheet1","Method 1","Method 2","Method 3","Method 4","VBA","LSI"],"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":"Sheet1","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Converting Number to Date Format"]
[]
[null,"Serial Number",null,"Date Format",null,"8 Digit Number"]
[null,40839,null,{"$f":"DATE(LEFT(F6,4),MID(F6,5,2),RIGHT(F6,2))","v":"2011-10-23"},null,20111023]
[null,41263,null,"2012-12-20",null,20121220]
[null,42140,null,"2015-05-16",null,20150516]
[null,41538,null,"2013-09-21",null,20130921]
[null,40317,null,"2010-05-19",null,20100519]
[null,44645,null,"2022-03-25",null,20220325]

{"sheet":"Method 1","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[10,1,10,2],[12,1,12,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[]
[]
[null,"Converting Number to Date Format"]
[]
[null,"Number to Date"]
[null,"2011-10-23"]
[null,"2011-10-24"]
[null,"2011-10-25"]
[null,"2011-10-26"]
[null,"2011-10-27"]
[null,"2011-10-28"]

{"sheet":"Method 2","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Converting Number to Date Format"]
[]
[null,"Number Format","Date Format"]
[null,20111023,{"$f":"DATE(LEFT(B6,4),MID(B6,5,2),RIGHT(B6,2))","v":"2011-10-23"}]
[null,20121220,{"$f":"DATE(LEFT(B7,4),MID(B7,5,2),RIGHT(B7,2))","v":"2012-12-20"}]
[null,20150516,"2015-05-16"]
[null,20130921,"2013-09-21"]
[null,20100519,"2010-05-19"]
[null,20220325,"2022-03-25"]

{"sheet":"Method 3","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Converting Number to Date Format"]
[]
[null,"Serial Number","Date Format"]
[null,40839,{"$f":"TEXT(B6,\"yyyy-mm-dd\")","v":"2011-10-23"}]
[null,41263,{"$f":"TEXT(B7,\"yyyy-mm-dd\")","v":"2012-12-20"}]
[null,42140,"2015-05-16"]
[null,41538,"2013-09-21"]
[null,40317,"2010-05-19"]
[null,44645,"2022-03-25"]

{"sheet":"Method 4","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Converting Number to Date Format"]
[]
[null,"Number Format","Date Format"]
[null,20111023,"2011-10-23"]
[null,20121220,"2012-12-20"]
[null,20150516,"2015-05-16"]
[null,20130921,"2013-09-21"]
[null,20100519,"2010-05-19"]
[null,20220325,"2022-03-25"]

{"sheet":"VBA","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,1,8,2],[9,1,9,2],[10,1,10,2],[2,1,2,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2]]}
[]
[]
[null,"Converting Number to Date Format"]
[]
[null,"Number to Date"]
[null,"2011-10-23"]
[null,"2012-12-20"]
[null,"2015-05-16"]
[null,"2013-09-21"]
[null,"2014-03-19"]
[null,"2022-03-25"]

{"sheet":"LSI","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Converting Text to Date Format"]
[]
[null,"Text","Date Format"]
[null,"10-12-2022",{"$f":"DATEVALUE(B6)","v":"2022-10-12"}]
[null,"10-25-2021",{"$f":"DATEVALUE(B7)","v":"2021-10-25"}]
[null,"05-21-2022","2022-05-21"]
[null,"06-29-2019","2019-06-29"]
[null,"03-09-2014","2014-03-09"]
[null,"1-11-2017","2017-01-11"]