{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Home Tab","Format Cell (Date)","Format Cell (Custom)","TEXT Function","VBA Code(1)","VBA Code (2)"],"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":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,1,3,7],[1,1,1,7]]}
[]
[null,"Short Date Number Format Excel"]
[]
[null,"TESLA Stock Price in December, 2022"]
[]
[null,"Date","Open","High","Low","Close","Adj Close","Volume"]
[null,"2022-12-01",197.08000200000001,198.91999799999999,191.800003,194.699997,194.699997,80046200]
[null,"2022-12-02",191.779999,196.25,191.11000100000001,194.86000100000001,194.86000100000001,73645900]
[null,"2022-12-05",189.44000199999999,191.270004,180.550003,182.449997,182.449997,93122700]
[null,"2022-12-06",181.220001,183.64999399999999,175.33000200000001,179.820007,179.820007,92150800]
[null,"2022-12-07",175.029999,179.38000500000001,172.220001,174.03999300000001,174.03999300000001,84213300]
[null,"2022-12-08",172.199997,175.199997,169.05999800000001,173.44000199999999,173.44000199999999,97624500]
[null,"2022-12-09",173.83999600000001,182.5,173.36000100000001,179.050003,179.050003,104872300]
[null,"2022-12-12",176.10000600000001,177.36999499999999,167.520004,167.820007,167.820007,109794500]
[null,"2022-12-13",174.86999499999999,175.050003,156.91000399999999,160.949997,160.949997,175862700]
[null,"2022-12-14",159.25,161.61999499999999,155.30999800000001,156.800003,156.800003,140682300]
[null,"2022-12-15",153.44000199999999,160.929993,153.279999,157.66999799999999,157.66999799999999,122334500]
[null,"2022-12-16",159.63999899999999,160.990005,150.03999300000001,150.229996,150.229996,139032200]
[null,"2022-12-19",154,155.25,145.820007,149.86999499999999,149.86999499999999,139390600]
[null,"2022-12-20",146.050003,148.470001,137.66000399999999,137.800003,137.800003,159563300]
[null,"2022-12-21",139.33999600000001,141.259995,135.88999899999999,137.570007,137.570007,145417400]
[null,"2022-12-22",136,136.63000500000001,122.260002,125.349998,125.349998,210090300]
[null,"2022-12-23",126.370003,128.61999499999999,121.019997,123.150002,123.150002,166989700]
[null,"2022-12-27",117.5,119.66999800000001,108.760002,109.099998,109.099998,208643400]
[null,"2022-12-28",110.349998,116.269997,108.239998,112.709999,112.709999,221070500]
[null,"2022-12-29",120.389999,123.57,117.5,121.82,121.82,221923300]
[null,"2022-12-30",119.949997,124.480003,119.75,123.18,123.18,157304500]
[]
[null,"Procedures","Input","Output"]
[]
[null,"1. Home tab","2022-12-01","2022-12-01"]
[null,"2. Cell Format (Date)","2023-12-01","2022-12-01"]
[null,"3. Cell Format (Custom)","2022-12-01","2022-12-01"]
[null,"4. TEXT Function","2023-12-01","2022-12-01"]
[null,"5. VBA Code (1)","2022-12-01","2022-12-01"]
[null,"6. VBA Code (2)","2022-12-01","2022-12-01"]

{"sheet":"Home Tab","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7]]}
[]
[null,"Home Tab"]
[]
[null,"TESLA Stock Price in December, 2022"]
[]
[null,"Date","Open","High","Low","Close","Adj Close","Volume"]
[null,"2022-12-01",197.08000200000001,198.91999799999999,191.800003,"1900-07-12T16:47:59.741",194.699997,80046200]
[null,"2022-12-02",191.779999,196.25,191.11000100000001,194.86000100000001,194.86000100000001,73645900]
[null,"2022-12-05",189.44000199999999,191.270004,180.550003,182.449997,182.449997,93122700]
[null,"2022-12-06",181.220001,183.64999399999999,175.33000200000001,179.820007,179.820007,92150800]
[null,"2022-12-07",175.029999,179.38000500000001,172.220001,174.03999300000001,174.03999300000001,84213300]
[null,"2022-12-08",172.199997,175.199997,169.05999800000001,173.44000199999999,173.44000199999999,97624500]
[null,"2022-12-09",173.83999600000001,182.5,173.36000100000001,179.050003,179.050003,104872300]
[null,"2022-12-12",176.10000600000001,177.36999499999999,167.520004,167.820007,167.820007,109794500]
[null,"2022-12-13",174.86999499999999,175.050003,156.91000399999999,160.949997,160.949997,175862700]
[null,"2022-12-14",159.25,161.61999499999999,155.30999800000001,156.800003,156.800003,140682300]
[null,"2022-12-15",153.44000199999999,160.929993,153.279999,157.66999799999999,157.66999799999999,122334500]
[null,"2022-12-16",159.63999899999999,160.990005,150.03999300000001,150.229996,150.229996,139032200]
[null,"2022-12-19",154,155.25,145.820007,149.86999499999999,149.86999499999999,139390600]
[null,"2022-12-20",146.050003,148.470001,137.66000399999999,137.800003,137.800003,159563300]
[null,"2022-12-21",139.33999600000001,141.259995,135.88999899999999,137.570007,137.570007,145417400]
[null,"2022-12-22",136,136.63000500000001,122.260002,125.349998,125.349998,210090300]
[null,"2022-12-23",126.370003,128.61999499999999,121.019997,123.150002,123.150002,166989700]
[null,"2022-12-27",117.5,119.66999800000001,108.760002,109.099998,109.099998,208643400]
[null,"2022-12-28",110.349998,116.269997,108.239998,112.709999,112.709999,221070500]
[null,"2022-12-29",120.389999,123.57,117.5,121.82,121.82,221923300]
[null,"2022-12-30",119.949997,124.480003,119.75,123.18,123.18,157304500]

{"sheet":"Format Cell (Date)","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7]]}
[]
[null,"Using the Format Cell (Date)"]
[]
[null,"TESLA Stock Price in December, 2022"]
[]
[null,"Date","Open","High","Low","Close","Adj Close","Volume"]
[null,"2022-12-01",197.08000200000001,198.91999799999999,191.800003,194.699997,194.699997,80046200]
[null,"2022-12-02",191.779999,196.25,191.11000100000001,194.86000100000001,194.86000100000001,73645900]
[null,"2022-12-05",189.44000199999999,191.270004,180.550003,182.449997,182.449997,93122700]
[null,"2022-12-06",181.220001,183.64999399999999,175.33000200000001,179.820007,179.820007,92150800]
[null,"2022-12-07",175.029999,179.38000500000001,172.220001,174.03999300000001,174.03999300000001,84213300]
[null,"2022-12-08",172.199997,175.199997,169.05999800000001,173.44000199999999,173.44000199999999,97624500]
[null,"2022-12-09",173.83999600000001,182.5,173.36000100000001,179.050003,179.050003,104872300]
[null,"2022-12-12",176.10000600000001,177.36999499999999,167.520004,167.820007,167.820007,109794500]
[null,"2022-12-13",174.86999499999999,175.050003,156.91000399999999,160.949997,160.949997,175862700]
[null,"2022-12-14",159.25,161.61999499999999,155.30999800000001,156.800003,156.800003,140682300]
[null,"2022-12-15",153.44000199999999,160.929993,153.279999,157.66999799999999,157.66999799999999,122334500]
[null,"2022-12-16",159.63999899999999,160.990005,150.03999300000001,150.229996,150.229996,139032200]
[null,"2022-12-19",154,155.25,145.820007,149.86999499999999,149.86999499999999,139390600]
[null,"2022-12-20",146.050003,148.470001,137.66000399999999,137.800003,137.800003,159563300]
[null,"2022-12-21",139.33999600000001,141.259995,135.88999899999999,137.570007,137.570007,145417400]
[null,"2022-12-22",136,136.63000500000001,122.260002,125.349998,125.349998,210090300]
[null,"2022-12-23",126.370003,128.61999499999999,121.019997,123.150002,123.150002,166989700]
[null,"2022-12-27",117.5,119.66999800000001,108.760002,109.099998,109.099998,208643400]
[null,"2022-12-28",110.349998,116.269997,108.239998,112.709999,112.709999,221070500]
[null,"2022-12-29",120.389999,123.57,117.5,121.82,121.82,221923300]
[null,"2022-12-30",119.949997,124.480003,119.75,123.18,123.18,157304500]

{"sheet":"Format Cell (Custom)","index":3,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7]]}
[]
[null,"Using the Format Cell (Custom)"]
[]
[null,"TESLA Stock Price in December, 2022"]
[]
[null,"Date","Open","High","Low","Close","Adj Close","Volume"]
[null,"2022-12-01",197.08000200000001,198.91999799999999,191.800003,194.699997,194.699997,80046200]
[null,"2022-12-02",191.779999,196.25,191.11000100000001,194.86000100000001,194.86000100000001,73645900]
[null,"2022-12-05",189.44000199999999,191.270004,180.550003,182.449997,182.449997,93122700]
[null,"2022-12-06",181.220001,183.64999399999999,175.33000200000001,179.820007,179.820007,92150800]
[null,"2022-12-07",175.029999,179.38000500000001,172.220001,174.03999300000001,174.03999300000001,84213300]
[null,"2022-12-08",172.199997,175.199997,169.05999800000001,173.44000199999999,173.44000199999999,97624500]
[null,"2022-12-09",173.83999600000001,182.5,173.36000100000001,179.050003,179.050003,104872300]
[null,"2022-12-12",176.10000600000001,177.36999499999999,167.520004,167.820007,167.820007,109794500]
[null,"2022-12-13",174.86999499999999,175.050003,156.91000399999999,160.949997,160.949997,175862700]
[null,"2022-12-14",159.25,161.61999499999999,155.30999800000001,156.800003,156.800003,140682300]
[null,"2022-12-15",153.44000199999999,160.929993,153.279999,157.66999799999999,157.66999799999999,122334500]
[null,"2022-12-16",159.63999899999999,160.990005,150.03999300000001,150.229996,150.229996,139032200]
[null,"2022-12-19",154,155.25,145.820007,149.86999499999999,149.86999499999999,139390600]
[null,"2022-12-20",146.050003,148.470001,137.66000399999999,137.800003,137.800003,159563300]
[null,"2022-12-21",139.33999600000001,141.259995,135.88999899999999,137.570007,137.570007,145417400]
[null,"2022-12-22",136,136.63000500000001,122.260002,125.349998,125.349998,210090300]
[null,"2022-12-23",126.370003,128.61999499999999,121.019997,123.150002,123.150002,166989700]
[null,"2022-12-27",117.5,119.66999800000001,108.760002,109.099998,109.099998,208643400]
[null,"2022-12-28",110.349998,116.269997,108.239998,112.709999,112.709999,221070500]
[null,"2022-12-29",120.389999,123.57,117.5,121.82,121.82,221923300]
[null,"2022-12-30",119.949997,124.480003,119.75,123.18,123.18,157304500]

{"sheet":"TEXT Function","index":4,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8]]}
[]
[null,"Using TEXT Function"]
[]
[null,"TESLA Stock Price in December, 2022"]
[]
[null,"Date","Date (TEXT)","Open","High","Low","Close","Adj Close","Volume"]
[null,"2022-12-01",{"$f":"TEXT(B7:B27,\"mm/d/yyyy\")","v":"12/1/2022"},197.08000200000001,198.91999799999999,191.800003,194.699997,194.699997,80046200]
[null,"2022-12-02","12/2/2022",191.779999,196.25,191.11000100000001,194.86000100000001,194.86000100000001,73645900]
[null,"2022-12-05","12/5/2022",189.44000199999999,191.270004,180.550003,182.449997,182.449997,93122700]
[null,"2022-12-06","12/6/2022",181.220001,183.64999399999999,175.33000200000001,179.820007,179.820007,92150800]
[null,"2022-12-07","12/7/2022",175.029999,179.38000500000001,172.220001,174.03999300000001,174.03999300000001,84213300]
[null,"2022-12-08","12/8/2022",172.199997,175.199997,169.05999800000001,173.44000199999999,173.44000199999999,97624500]
[null,"2022-12-09","12/9/2022",173.83999600000001,182.5,173.36000100000001,179.050003,179.050003,104872300]
[null,"2022-12-12","12/12/2022",176.10000600000001,177.36999499999999,167.520004,167.820007,167.820007,109794500]
[null,"2022-12-13","12/13/2022",174.86999499999999,175.050003,156.91000399999999,160.949997,160.949997,175862700]
[null,"2022-12-14","12/14/2022",159.25,161.61999499999999,155.30999800000001,156.800003,156.800003,140682300]
[null,"2022-12-15","12/15/2022",153.44000199999999,160.929993,153.279999,157.66999799999999,157.66999799999999,122334500]
[null,"2022-12-16","12/16/2022",159.63999899999999,160.990005,150.03999300000001,150.229996,150.229996,139032200]
[null,"2022-12-19","12/19/2022",154,155.25,145.820007,149.86999499999999,149.86999499999999,139390600]
[null,"2022-12-20","12/20/2022",146.050003,148.470001,137.66000399999999,137.800003,137.800003,159563300]
[null,"2022-12-21","12/21/2022",139.33999600000001,141.259995,135.88999899999999,137.570007,137.570007,145417400]
[null,"2022-12-22","12/22/2022",136,136.63000500000001,122.260002,125.349998,125.349998,210090300]
[null,"2022-12-23","12/23/2022",126.370003,128.61999499999999,121.019997,123.150002,123.150002,166989700]
[null,"2022-12-27","12/27/2022",117.5,119.66999800000001,108.760002,109.099998,109.099998,208643400]
[null,"2022-12-28","12/28/2022",110.349998,116.269997,108.239998,112.709999,112.709999,221070500]
[null,"2022-12-29","12/29/2022",120.389999,123.57,117.5,121.82,121.82,221923300]
[null,"2022-12-30","12/30/2022",119.949997,124.480003,119.75,123.18,123.18,157304500]

{"sheet":"VBA Code(1)","index":5,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7]]}
[]
[null,"Using VBA Code (1)"]
[]
[null,"TESLA Stock Price in December, 2022"]
[]
[null,"Date","Open","High","Low","Close","Adj Close","Volume"]
[null,"2022-12-01",197.08000200000001,198.91999799999999,191.800003,194.699997,194.699997,80046200]
[null,"2022-12-02",191.779999,196.25,191.11000100000001,194.86000100000001,194.86000100000001,73645900]
[null,"2022-12-05",189.44000199999999,191.270004,180.550003,182.449997,182.449997,93122700]
[null,"2022-12-06",181.220001,183.64999399999999,175.33000200000001,179.820007,179.820007,92150800]
[null,"2022-12-07",175.029999,179.38000500000001,172.220001,174.03999300000001,174.03999300000001,84213300]
[null,"2022-12-08",172.199997,175.199997,169.05999800000001,173.44000199999999,173.44000199999999,97624500]
[null,"2022-12-09",173.83999600000001,182.5,173.36000100000001,179.050003,179.050003,104872300]
[null,"2022-12-12",176.10000600000001,177.36999499999999,167.520004,167.820007,167.820007,109794500]
[null,"2022-12-13",174.86999499999999,175.050003,156.91000399999999,160.949997,160.949997,175862700]
[null,"2022-12-14",159.25,161.61999499999999,155.30999800000001,156.800003,156.800003,140682300]
[null,"2022-12-15",153.44000199999999,160.929993,153.279999,157.66999799999999,157.66999799999999,122334500]
[null,"2022-12-16",159.63999899999999,160.990005,150.03999300000001,150.229996,150.229996,139032200]
[null,"2022-12-19",154,155.25,145.820007,149.86999499999999,149.86999499999999,139390600]
[null,"2022-12-20",146.050003,148.470001,137.66000399999999,137.800003,137.800003,159563300]
[null,"2022-12-21",139.33999600000001,141.259995,135.88999899999999,137.570007,137.570007,145417400]
[null,"2022-12-22",136,136.63000500000001,122.260002,125.349998,125.349998,210090300]
[null,"2022-12-23",126.370003,128.61999499999999,121.019997,123.150002,123.150002,166989700]
[null,"2022-12-27",117.5,119.66999800000001,108.760002,109.099998,109.099998,208643400]
[null,"2022-12-28",110.349998,116.269997,108.239998,112.709999,112.709999,221070500]
[null,"2022-12-29",120.389999,123.57,117.5,121.82,121.82,221923300]
[null,"2022-12-30",119.949997,124.480003,119.75,123.18,123.18,157304500]

{"sheet":"VBA Code (2)","index":6,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7]]}
[]
[null,"Using VBA Code (2)"]
[]
[null,"TESLA Stock Price in December, 2022"]
[]
[null,"Date","Open","High","Low","Close","Adj Close","Volume"]
[null,"2022-12-01",197.08000200000001,198.91999799999999,191.800003,194.699997,194.699997,80046200]
[null,"2022-12-02",191.779999,196.25,191.11000100000001,194.86000100000001,194.86000100000001,73645900]
[null,"2022-12-05",189.44000199999999,191.270004,180.550003,182.449997,182.449997,93122700]
[null,"2022-12-06",181.220001,183.64999399999999,175.33000200000001,179.820007,179.820007,92150800]
[null,"2022-12-07",175.029999,179.38000500000001,172.220001,174.03999300000001,174.03999300000001,84213300]
[null,"2022-12-08",172.199997,175.199997,169.05999800000001,173.44000199999999,173.44000199999999,97624500]
[null,"2022-12-09",173.83999600000001,182.5,173.36000100000001,179.050003,179.050003,104872300]
[null,"2022-12-12",176.10000600000001,177.36999499999999,167.520004,167.820007,167.820007,109794500]
[null,"2022-12-13",174.86999499999999,175.050003,156.91000399999999,160.949997,160.949997,175862700]
[null,"2022-12-14",159.25,161.61999499999999,155.30999800000001,156.800003,156.800003,140682300]
[null,"2022-12-15",153.44000199999999,160.929993,153.279999,157.66999799999999,157.66999799999999,122334500]
[null,"2022-12-16",159.63999899999999,160.990005,150.03999300000001,150.229996,150.229996,139032200]
[null,"2022-12-19",154,155.25,145.820007,149.86999499999999,149.86999499999999,139390600]
[null,"2022-12-20",146.050003,148.470001,137.66000399999999,137.800003,137.800003,159563300]
[null,"2022-12-21",139.33999600000001,141.259995,135.88999899999999,137.570007,137.570007,145417400]
[null,"2022-12-22",136,136.63000500000001,122.260002,125.349998,125.349998,210090300]
[null,"2022-12-23",126.370003,128.61999499999999,121.019997,123.150002,123.150002,166989700]
[null,"2022-12-27",117.5,119.66999800000001,108.760002,109.099998,109.099998,208643400]
[null,"2022-12-28",110.349998,116.269997,108.239998,112.709999,112.709999,221070500]
[null,"2022-12-29",120.389999,123.57,117.5,121.82,121.82,221923300]
[null,"2022-12-30",119.949997,124.480003,119.75,123.18,123.18,157304500]