{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sheet1","Number Format Drop-Down ","Built-In Date Format Option","Create Custom Date Formatting","Use of TEXT Function","DATE, RIGHT, MID, LEFT Function","VBA "],"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Overview of Converting Number to Date"]
[]
[null,"Customer","Payment","Date"]
[null,"Bob","Cash","2020-06-06"]
[null,"Tom","Card","2020-06-07"]
[null,"Lily","Cash","2020-06-08"]
[null,"Rob","Cash","2020-06-09"]
[null,"Mike","Card","2020-06-10"]
[null,"Brade","Cash","2020-06-11"]

{"sheet":"Number Format Drop-Down ","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,7,4,9]]}
[]
[null,"Use of Number Format Drop-Down "]
[]
[null,"Customer","Payment","Date"]
[null,"Bob","Cash","2020-06-06",null,null,null,"Try Yourself"]
[null,"Tom","Card","2020-06-07"]
[null,"Lily","Cash","2020-06-08",null,null,null,"Customer","Payment","Date"]
[null,"Rob","Cash","2020-06-09",null,null,null,"Bob","Cash",43988]
[null,"Mike","Card","2020-06-10",null,null,null,"Tom","Card",43989]
[null,"Brade","Cash","2020-06-11",null,null,null,"Lily","Cash",43990]
[null,null,null,null,null,null,null,"Rob","Cash",43991]
[null,null,null,null,null,null,null,"Mike","Card",43992]
[null,null,null,null,null,null,null,"Brade","Cash",43993]

{"sheet":"Built-In Date Format Option","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,6,3,8]]}
[]
[null,"Built-In Date Format Option"]
[]
[null,"Customer","Pay Amount","Date",null,null,"Try Yourself"]
[null,"Bob",500,"2020-06-06"]
[null,"Tom",300,"2020-06-07",null,null,"Customer","Pay Amount","Date"]
[null,"Lily",400,"2020-06-08",null,null,"Bob",500,43988]
[null,"Rob",600,"2020-06-09",null,null,"Tom",300,43989]
[null,"Mike",400,"2020-06-10",null,null,"Lily",400,43990]
[null,"Brade",200,"2020-06-11",null,null,"Rob",600,43991]
[null,null,null,null,null,null,"Mike",400,43992]
[null,null,null,null,null,null,"Brade",200,43993]

{"sheet":"Create Custom Date Formatting","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,6,2,8]]}
[]
[null,"Create Custom Date Formatting"]
[null,null,null,null,null,null,"Try Yourself"]
[null,"Customer","Payment","Date"]
[null,"Bob","Cash","2020-06-06",null,null,"Customer","Payment","Date"]
[null,"Tom","Card","2020-06-07",null,null,"Bob","Cash",43988]
[null,"Lily","Cash","2020-06-08",null,null,"Tom","Card",43989]
[null,"Rob","Cash","2020-06-09",null,null,"Lily","Cash",43990]
[null,"Mike","Card","2020-06-10",null,null,"Rob","Cash",43991]
[null,"Brade","Cash","2020-06-11",null,null,"Mike","Card",43992]
[null,null,null,null,null,null,"Brade","Cash",43993]

{"sheet":"Use of TEXT Function","index":4,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,6,4,8]]}
[]
[null,"Use of TEXT Function"]
[]
[null,"Payment","Number","Date"]
[null,500,43988,{"$f":"TEXT(C5,\"dd-mm-yyyy\")","v":"06-06-2020"},null,null,"Try Yourself"]
[null,300,43989,{"$f":"TEXT(C6,\"dd-mm-yyyy\")","v":"07-06-2020"}]
[null,400,43990,"08-06-2020",null,null,"Payment","Number","Date"]
[null,600,43991,"09-06-2020",null,null,500,43988]
[null,400,43992,"10-06-2020",null,null,300,43989]
[null,200,43993,"11-06-2020",null,null,400,43990]
[null,null,null,null,null,null,600,43991]
[null,null,null,null,null,null,400,43992]
[null,null,null,null,null,null,200,43993]

{"sheet":"DATE, RIGHT, MID, LEFT Function","index":5,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,6,4,8]]}
[]
[null,"Use of DATE, RIGHT, MID, LEFT Functions"]
[]
[null,"Payment","Number","Date"]
[null,"Cash",16062020,{"$f":"DATE(RIGHT(C5,4),MID(C5,3,2),LEFT(C5,2))","v":"2020-06-16"},null,null,"Try Yourself"]
[null,"Card",17062020,{"$f":"DATE(RIGHT(C6,4),MID(C6,3,2),LEFT(C6,2))","v":"2020-06-17"}]
[null,"Cash",18062020,"2020-06-18",null,null,"Payment","Number","Date"]
[null,"Cash",19062020,"2020-06-19",null,null,"Cash",16062020]
[null,"Card",10062020,"2020-06-10",null,null,"Card",17062020]
[null,"Cash",11062020,"2020-06-11",null,null,"Cash",18062020]
[null,null,null,null,null,null,"Cash",19062020]
[null,null,null,null,null,null,"Card",10062020]
[null,null,null,null,null,null,"Cash",11062020]

{"sheet":"VBA ","index":6,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA"]
[]
[null,"Payment","Number","Date"]
[null,500,43988,"2020-06-06"]
[null,300,43989,"2020-06-07"]
[null,400,43990,"2020-06-08"]
[null,600,43991,"2020-06-09"]
[null,400,43992,"2020-06-10"]
[null,200,43993,"2020-06-11"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"00:00:00"]