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

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

{"sheet":"Format","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,8]]}
[]
[null,"Format Number with VBA Format Function",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Original Number","Formatted Number","VBA Code",null,null,null,"Original Number","Formatted Number"]
[null,12345,12345,"Range(\"C5\") = Format(Range(\"C5\"), \"#,##0.00\")",null,null,null,12345,12345]
[null,12345,12345,"Range(\"C6\") = Format(Range(\"C6\"), \"$#,##\")",null,null,null,12345,12345]
[null,12345,12345,"Range(\"C7\") = Format(Range(\"C7\"), \"0.00%\")",null,null,null,12345,12345]
[null,12345,12300,"Range(\"C8\") = Format(Range(\"C8\"), \"Scientific\")",null,null,null,12345,12345]
[null,12345,"12345 Kg","Range(\"C9\") = Format(Range(\"C9\"), \"0#\"\" Kg\"\"\")",null,null,null,12345,12345]
[null,12345,"1-2-3-4-5","Range(\"C10\") = Format(Range(\"C10\"), \"#-#-#-#-#\")",null,null,null,12345,12345]
[null,12345,12345,"Range(\"C11\") = Format(Range(\"C11\"), \"#,##0.00\")",null,null,null,12345,12345]
[null,12345,12345,"Range(\"C12\") = Format(Range(\"C12\"), \"#,##0\")",null,null,null,12345,12345]
[null,12345,"1933-10-18","Range(\"C13\") = Format(Range(\"C13\"), \"Short Date\")",null,null,null,12345,12345]
[null,12345,"Wednesday, October 18, 1933","Range(\"C14\") = Format(Range(\"C14\"), \"Long Date\")",null,null,null,12345,12345]
[null,12345,"1933-10-18","Range(\"C15\") = Format(Range(\"C15\"), \"Medium Date\")",null,null,null,12345,12345]

{"sheet":"FormatNumber","index":3,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,8]]}
[]
[null,"Format Number with VBA FormatNumber Function",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Original Number","Formatted Number","VBA Code",null,null,null,"Original Number","Formatted Number"]
[null,12345,"12,345.00","Range(\"C5\") = FormatNumber(Range(\"C5\"), 2)",null,null,null,12345,12345]
[null,12345,"12345.00","Range(\"C6\") = FormatNumber(Range(\"C6\"), 2, , , vbFalse)",null,null,null,12345,12345]
[null,-12345,"(12,345.00)","Range(\"C7\") = FormatNumber(Range(\"C7\"), 2, , vbTrue)",null,null,null,-12345,-12345]