{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Dataset (2)","Number to Date (2)","Number to Date MDY format","Number to Date","Change format","Overview"],"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":"Dataset","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Text to Columns Operation in Excel VBA for Date Format"]
[]
[null,"ID","Name","Date","Attendance"]
[null,201111050,"Alan",101121,"Present"]
[null,201111050,"Alan",111121,"Present"]
[null,201111050,"Alan",121121,"Present"]
[null,201111050,"Alan",131121,"Absent"]
[null,201111050,"Alan",141121,"Present"]
[null,201111050,"Alan",151121,"Present"]
[null,201111050,"Alan",161121,"Absent"]
[null,201111050,"Alan",171121,"Present"]

{"sheet":"Dataset (2)","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Text to Columns Operation in Excel VBA for Date Format"]
[]
[null,"ID","Name","Date","Attendance"]
[null,201111050,"Alan",111021,"Present"]
[null,201111050,"Alan",111121,"Present"]
[null,201111050,"Alan",111221,"Present"]
[null,201111050,"Alan",111321,"Absent"]
[null,201111050,"Alan",111421,"Present"]
[null,201111050,"Alan",111521,"Present"]
[null,201111050,"Alan",111621,"Absent"]
[null,201111050,"Alan",111721,"Present"]

{"sheet":"Number to Date (2)","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Text to Columns Operation in Excel VBA for Date Format"]
[]
[null,"ID","Name","Date","Attendance"]
[null,201111050,"Alan","2021-11-10","Present"]
[null,201111050,"Alan","2021-11-11","Present"]
[null,201111050,"Alan","2021-11-12","Present"]
[null,201111050,"Alan","2021-11-13","Absent"]
[null,201111050,"Alan","2021-11-14","Present"]
[null,201111050,"Alan","2021-11-15","Present"]
[null,201111050,"Alan","2021-11-16","Absent"]
[null,201111050,"Alan","2021-11-17","Present"]

{"sheet":"Number to Date MDY format","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Text to Columns Operation in Excel VBA for Date Format"]
[]
[null,"ID","Name","Date","Attendance"]
[null,201111050,"Alan","2021-11-10","Present"]
[null,201111050,"Alan","2021-11-11","Present"]
[null,201111050,"Alan","2021-11-12","Present"]
[null,201111050,"Alan","2021-11-13","Absent"]
[null,201111050,"Alan","2021-11-14","Present"]
[null,201111050,"Alan","2021-11-15","Present"]
[null,201111050,"Alan","2021-11-16","Absent"]
[null,201111050,"Alan","2021-11-17","Present"]

{"sheet":"Number to Date","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Changing Date Format"]
[]
[null,"ID","Name","Date","Attendance"]
[null,201111050,"Alan","2021-11-10","Present"]
[null,201111050,"Alan","2021-11-11","Present"]
[null,201111050,"Alan","2021-11-12","Present"]
[null,201111050,"Alan","2021-11-13","Absent"]
[null,201111050,"Alan","2021-11-14","Present"]
[null,201111050,"Alan","2021-11-15","Present"]
[null,201111050,"Alan","2021-11-16","Absent"]
[null,201111050,"Alan","2021-11-17","Present"]

{"sheet":"Change format","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Changing Date Format"]
[]
[null,"ID","Name","Date","Attendance"]
[null,201111050,"Alan","2021-10-11","Present"]
[null,201111050,"Alan","2021-11-11","Present"]
[null,201111050,"Alan","2021-12-11","Present"]
[null,201111050,"Alan","13/11/2021","Absent"]
[null,201111050,"Alan","14/11/2021","Present"]
[null,201111050,"Alan","15/11/2021","Present"]
[null,201111050,"Alan","16/11/2021","Absent"]
[null,201111050,"Alan","17/11/2021","Present"]

{"sheet":"Overview","index":6,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Overview of Text to Columns Operation in Excel VBA for Date Format"]
[]
[null,"ID","Name","Date","Attendance",null,"ID","Name","Date","Attendance"]
[null,201111050,"Alan",101121,"Present",null,201111050,"Alan","2021-11-10","Present"]
[null,201111050,"Alan",111121,"Present",null,201111050,"Alan","2021-11-11","Present"]
[null,201111050,"Alan",121121,"Present",null,201111050,"Alan","2021-11-12","Present"]
[null,201111050,"Alan",131121,"Absent",null,201111050,"Alan","2021-11-13","Absent"]
[null,201111050,"Alan",141121,"Present",null,201111050,"Alan","2021-11-14","Present"]
[null,201111050,"Alan",151121,"Present",null,201111050,"Alan","2021-11-15","Present"]
[null,201111050,"Alan",161121,"Absent",null,201111050,"Alan","2021-11-16","Absent"]
[null,201111050,"Alan",171121,"Present",null,201111050,"Alan","2021-11-17","Present"]