{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","DATE","TEXT","Text to Column","VBA Macro","Different Available Date Format"],"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Number (yyyymmdd)","Number"]
[null,20120327,43566]
[null,20130112,44235]
[null,19980612,40222]
[null,19970112,41255]
[null,19950214,42557]
[null,19650523,45999]

{"sheet":"DATE","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using DATE with RIGHT, LEFT & MID Formulas"]
[]
[null,"Number (yyyymmdd)","Date "]
[null,20120327,{"$f":"DATE(LEFT(B5,4),MID(B5,5,2),RIGHT(B5,2))","v":"2012-03-27"}]
[null,20130112,{"$f":"DATE(LEFT(B6,4),MID(B6,5,2),RIGHT(B6,2))","v":"2013-01-12"}]
[null,19980612,"1998-06-12"]
[null,19970112,"1997-01-12"]
[null,19950214,"1995-02-14"]
[null,19650523,"1965-05-23"]

{"sheet":"TEXT","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using TEXT Formula"]
[]
[null,"Number ","Date "]
[null,43566,{"$f":"TEXT(B5,\"mm/dd/yyyy\")","v":"04/11/2019"}]
[null,44235,{"$f":"TEXT(B6,\"mm/dd/yyyy\")","v":"02/08/2021"}]
[null,40222,"02/13/2010"]
[null,41255,"12/12/2012"]
[null,42557,"07/06/2016"]
[null,45999,"12/08/2025"]

{"sheet":"Text to Column","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Text to Column"]
[]
[null,"Number (yyyymmdd)","Date"]
[null,20120327,"2012-03-27"]
[null,20130112,"2013-01-12"]
[null,19980612,"1998-06-12"]
[null,19970112,"1997-01-12"]
[null,19950214,"1995-02-14"]
[null,19650523,"1965-05-23"]

{"sheet":"VBA Macro","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using VBA Macro"]
[]
[null,"Number (yyyymmdd)"]
[null,"2012-03-27"]
[null,"2013-01-12"]
[null,"1998-06-12"]
[null,"1997-01-12"]
[null,"1995-02-14"]
[null,"1965-05-23"]

{"sheet":"Different Available Date Format","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,2,3,4],[1,1,1,4]]}
[]
[null,"Different Date Formats Available in Excel"]
[]
[null,"Number","Different Date Formats in Excel"]
[null,43566,"2019-04-11","2019-04-11","2019-04-11"]
[null,44235,"2021-02-08","2021-02-08","2021-02-08"]
[null,40222,"2010-02-13","2010-02-13","2010-02-13"]
[null,41255,"2012-12-12","2012-12-12","2012-12-12"]
[null,42557,"2016-07-06","2016-07-06","2016-07-06"]
[null,45999,"2025-12-08","2025-12-08","2025-12-08"]