{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["overview","method 1","method 2","method 3"],"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":"overview","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Excel VBA: Format Cell to Text"]
[]
[null,"Number Format",null,"Text Format"]
[null,"General",1000,1000]
[null,"Number",1025.6500000000001,1025.6500000000001]
[null,"Currency",1000,1000]
[null,"Accounting",10000,10000]
[null,"Short Date","2024-09-10",45545]
[null,"Long Date","2024-09-10",45545]
[null,"Time",45545.25,45545.25]
[null,"Percentage",0.5,0.5]
[null,"Fraction",2.25,2.25]
[null,"Scientific",100000000000000,100000000000000]

{"sheet":"method 1","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of the Range.NumberFormat to  Format Cell to Text"]
[]
[null,"Number Format"]
[null,"Short Date-Text"]
[null,45545]

{"sheet":"method 2","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Use of the TEXT Function to  Format Cell to Text"]
[]
[null,"Number Format"]
[null,"Long Date","Text"]
[null,"2024-09-10","45545"]

{"sheet":"method 3","index":3,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Use of the Format Function to  Format Cell to Text"]
[]
[null,"Number Format"]
[null,"Long Date","Text"]
[null,"2024-09-10","45545"]