{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Format Number","Range of Number"],"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":"Format Number","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Format Number with VBA"]
[]
[null,"Original Number","Formatted Number","VBA Code"]
[null,12345,12345,"Range(\"C5\").NumberFormat = \"#,##0.0\""]
[null,12345,12345,"Range(\"C6\").NumberFormat = \"$#,##0.0\""]
[null,12345,12345,"Range(\"C7\").NumberFormat = \"0.00%\""]
[null,-12345,-12345,"Range(\"C8\").NumberFormat = \"#,##.00;[red]-#,##.00\""]
[null,12345,12345,"Range(\"C9\").NumberFormat = \"#?/?\""]
[null,12345,12345,"Range(\"C10\").NumberFormat = \"0#\"\" Kg\"\"\""]
[null,12345,12345,"Range(\"C11\").NumberFormat = \"#-#-#-#-#\""]
[null,12345,12345,"Range(\"C12\").NumberFormat = \"#,##0.00\""]
[null,12345,12345,"Range(\"C13\").NumberFormat = \"#,##0\""]
[null,12345,12345,"Range(\"C14\").NumberFormat = \"#,##0.00\""]
[null,12345,"1933-10-18","Range(\"C15\").NumberFormat = \"dd-mmm-yyyy hh:mm AM/PM\""]

{"sheet":"Range of Number","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Format Range of Number with VBA"]
[]
[null,"Original Number","Formatted Number"]
[null,12345,12345]
[null,12345,12345]
[null,12345,12345]
[null,12345,12345]
[null,12345,12345]
[null,-12345,-12345]
[null,12345,12345]
[null,12345,12345]
[null,12345,12345]
[null,12345,12345]
[null,12345,12345]