{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Num","Curr","Date","Time","Date,Time","Percentage","Fraction","Sci","Tel","Zero","VBA_NUM","VBA_Percent","VBA_Logic","VBA_Date","VBA_Time","Remind"],"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":"Num","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,8,10,8],[1,8,1,9],[4,1,10,1],[1,1,1,3]]}
[]
[null,"Formatting Number",null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,"Value","Result"]
[null,1234567,{"$f":"TEXT($B$5,\"#,###.00\")","v":"1,234,567.00"},"=TEXT($C$5,\"#,###.00\")",null,null,null,null,1234567]
[null,null,{"$f":"TEXT($B$5,\"(#,###.00)\")","v":"(1,234,567.00)"},"=TEXT($C$5,\"(#,###.00)\")"]
[null,null,{"$f":"TEXT($B$5,\"-#,###.00\")","v":"-1,234,567.00"},"=TEXT($C$5,\"-#,###.00\")"]
[null,null,{"$f":"TEXT($B$5,\"#,###\")","v":"1,234,567"},"=TEXT($C$5,\"#,###\")"]
[null,null,{"$f":"TEXT($B$5,\"###,###\")","v":"1,234,567"},"=TEXT($C$5,\"###,###\")"]
[null,null,{"$f":"TEXT($B$5,\"####.00\")","v":"1234567.00"},"=TEXT($C$5,\"####.00\")"]
[null,null,{"$f":"TEXT($B$5,\"#.00\")","v":"1234567.00"},"=TEXT($C$5,\"#.00\")"]

{"sheet":"Curr","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,1,10,1],[1,1,1,3],[1,9,1,10],[4,9,10,9]]}
[]
[null,"Formatting Currency",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,null,"Value","Result"]
[null,1234567,{"$f":"TEXT($B$5,\"$#,###.00\")","v":"$1,234,567.00"},"=TEXT($C$12,\"$#,###.00\")",null,null,null,null,null,1234567]
[null,null,{"$f":"TEXT($B$5,\"($#,###.00)\")","v":"($1,234,567.00)"},"=TEXT($C$12,\"($#,###.00)\")"]
[null,null,{"$f":"TEXT($B$5,\"-$#,###.00\")","v":"-$1,234,567.00"},"=TEXT($C$12,\"-$#,###.00\")"]
[null,null,{"$f":"TEXT($B$5,\"￥#,###\")","v":"￥1,234,567"},"=TEXT($C$12,\"￥#,###\")"]
[null,null,{"$f":"TEXT($B$5,\"￥###,###\")","v":"￥1,234,567"},"=TEXT($C$12,\"￥###,###\")"]
[null,null,{"$f":"TEXT($B$5,\"$####.00\")","v":"$1234567.00"},"=TEXT($C$12,\"$####.00\")"]
[null,null,{"$f":"TEXT($B$5,\"$#.00\")","v":"$1234567.00"},"=TEXT($C$12,\"$#.00\")"]

{"sheet":"Date","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,9,12,9],[1,9,1,10],[1,1,1,3],[4,1,12,1]]}
[]
[null," Formatting Date",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,null,"Value","Result"]
[null,"2016-10-25",{"$f":"TEXT($B$5,\"DDMMMYYY\")","v":"25Oct2016"},"=TEXT($C$3,\"DDMMMYYY\")",null,null,null,null,null,"2016-10-25"]
[null,null,{"$f":"TEXT($B$5,\"DDMMMYY\")","v":"25Oct16"},"=TEXT($C$3,\"DDMMMYY\")"]
[null,null,{"$f":"TEXT($B$5,\"MMM DD, YYYY\")","v":"Oct 25, 2016"},"=TEXT($C$3,\"MMM DD, YYYY\")"]
[null,null,{"$f":"TEXT($B$5,\"DDDD\")","v":"Tuesday"},"=TEXT($C$3,\"DDDD\")"]
[null,null,{"$f":"TEXT($B$5,\"DDDD, DDMMMYYYY\")","v":"Tuesday, 25Oct2016"},"=TEXT($C$3,\"DDDD, DDMMMYYYY\")"]
[null,null,{"$f":"TEXT($B$5,\"DDDD, MMM DD, YYYY\")","v":"Tuesday, Oct 25, 2016"},"=TEXT($C$3,\"DDDD, MMM DD, YYYY\")"]
[null,null,{"$f":"TEXT($B$5,\"MM/DD/YYYY\")","v":"10/25/2016"},"=TEXT($C$3,\"MM/DD/YYYY\")"]
[null,null,{"$f":"TEXT($B$5,\"MM/DD\")","v":"10/25"},"=TEXT($C$3,\"MM/DD\")"]
[null,null,{"$f":"TEXT($B$5,\"YYYY-MM-DD\")","v":"2016-10-25"},"=TEXT($C$3,\"YYYY-MM-DD\")"]

{"sheet":"Time","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,9,1,10],[4,9,6,9],[1,1,1,3],[4,1,6,1]]}
[]
[null," Formatting Time",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,null,"Value","Result"]
[null,"10:28:00",{"$f":"TEXT($B$5,\"H:MM AM/PM\")","v":"10:28 AM"},"=TEXT($C$13,\"H:MM AM/PM\")",null,null,null,null,null,"10:28:00"]
[null,null,{"$f":"TEXT($B$5,\"H:MM:SS AM/PM\")","v":"10:28:00 AM"},"=TEXT($C$13,\"H:MM:SS AM/PM\")"]
[null,null,{"$f":"TEXT(NOW(),\"H:MM:SS AM/PM\")","v":"10:11:05 AM"},"=TEXT(NOW(),\"H:MM:SS AM/PM\")"]

{"sheet":"Date,Time","index":4,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,9,1,10],[4,9,6,9],[1,1,1,3],[4,1,6,1]]}
[]
[null," Formatting Date and Time",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,null,"Value","Result"]
[null,"2016-10-25T15:28:00",{"$f":"TEXT($B$5,\"MMM DD, YYYY H:MM:SS AM/PM\")","v":"Oct 25, 2016 3:28:00 PM"},"=TEXT($G$16,\"MMM DD, YYYY H:MM:SS AM/PM\")",null,null,null,null,null,"2016-10-25T15:28:00"]
[null,null,{"$f":"TEXT($B$5,\"YYYY-MM-DD H:MM AM/PM\")","v":"2016-10-25 3:28 PM"},"=TEXT($G$16,\"YYYY-MM-DD H:MM AM/PM\")"]
[null,null,{"$f":"TEXT($B$5,\"YYYY-MM-DD H:MM\")","v":"2016-10-25 15:28"},"=TEXT($G$16,\"YYYY-MM-DD H:MM\")"]

{"sheet":"Percentage","index":5,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,6,1],[1,10,1,11],[4,10,6,10]]}
[]
[null,"Formatting Percentage",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,null,null,"Value","Result"]
[null,0.28539999999999999,{"$f":"TEXT($B$5,\"0%\")","v":"29%"},"=TEXT($C$5,\"0%\")",null,null,null,null,null,null,0.28539999999999999]
[null,null,{"$f":"TEXT($B$5,\"0.0%\")","v":"28.5%"},"=TEXT($C$5,\"0.0%\")"]
[null,null,{"$f":"TEXT($B$5,\"0.00%\")","v":"28.54%"},"=TEXT($C$5,\"0.00%\")"]

{"sheet":"Fraction","index":6,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,9,1,10],[4,9,12,9],[4,1,12,1],[1,1,1,3]]}
[]
[null,"Formatting Fraction",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,null,"Value","Result"]
[null,4.6403816850000004,{"$f":"TEXT($B$5,\"?/?\")","v":"14/3"},"=TEXT($C$9,\"?/?\")",null,null,null,null,null,4.6403816850000004]
[null,null,{"$f":"TEXT($B$5,\"?/??\")","v":"413/89"},"=TEXT($C$9,\"?/??\")"]
[null,null,{"$f":"TEXT($B$5,\"?/???\")","v":"3884/837"},"=TEXT($C$9,\"?/???\")"]
[null,null,{"$f":"TEXT($B$5,\"?/2\")","v":"9/2"},"=TEXT($C$9,\"?/2\")"]
[null,null,{"$f":"TEXT($B$5,\"?/4\")","v":"19/4"},"=TEXT($C$9,\"?/4\")"]
[null,null,{"$f":"TEXT($B$5,\"?/8\")","v":"37/8"},"=TEXT($C$9,\"?/8\")"]
[null,null,{"$f":"TEXT($B$5,\"?/16\")","v":"74/16"},"=TEXT($C$9,\"?/16\")"]
[null,null,{"$f":"TEXT($B$5,\"?/10\")","v":"46/10"},"=TEXT($C$9,\"?/10\")"]
[null,null,{"$f":"TEXT($B$5,\"?/100\")","v":"464/100"},"=TEXT($C$9,\"?/100\")"]

{"sheet":"Sci","index":7,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,5,1],[1,9,1,10],[4,9,5,9]]}
[]
[null,"Formatting Scientific Number",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,null,"Value","Result"]
[null,13600000,{"$f":"TEXT($B$5,\"0.00E+00\")","v":"1.36E+07"},"=TEXT($C$5,\"0.00E+00\")",null,null,null,null,null,13600000]
[null,null,{"$f":"TEXT($B$5,\"0.0E+00\")","v":"1.4E+07"},"=TEXT($C$5,\"0.0E+00\")"]

{"sheet":"Tel","index":8,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,10]]}
[]
[null,"Formatting Telephone Number",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,null,"Value","Result"]
[null,"8613894425469",{"$f":"TEXT($B$5,\"(##) ###-###-#####\")","v":"(86) 138-944-25469"},"=TEXT($C$7,\"(##) ###-###-#####\")",null,null,null,null,null,"8613894425469"]

{"sheet":"Zero","index":9,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,9,1,10],[4,9,6,9],[4,1,6,1],[1,1,1,3]]}
[]
[null,"Formatting Zero Leading Values",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Formula",null,null,null,null,null,"Value","Result"]
[null,34,{"$f":"TEXT($B$5,\"00\")","v":"34"},"=TEXT($C$8,\"00\")",null,null,null,null,null,34]
[null,null,{"$f":"TEXT($B$5,\"000\")","v":"034"},"=TEXT($C$8,\"000\")"]
[null,null,{"$f":"TEXT($B$5,\"0000\")","v":"0034"},"=TEXT($C$8,\"0000\")"]

{"sheet":"VBA_NUM","index":10,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,9,1,11],[4,9,8,9],[1,1,1,3],[4,1,8,1]]}
[]
[null,"Formatting Number",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Code",null,null,null,null,null,"Value","Result","Code"]
[null,123456,123456,"Format(Cells(5, 2), \"General Number\")",null,null,null,null,null,123456,null,"Format(Cells(5, 2), \"General Number\")"]
[null,null,123456,"Format(Cells(5, 2), \"Currency\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"Currency\")"]
[null,null,123456,"Format(Cells(5, 2), \"Fixed\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"Fixed\")"]
[null,null,123456,"Format(Cells(5, 2), \"Standard\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"Standard\")"]
[null,null,123000,"Format(Cells(5, 2), \"Scientific\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"Scientific\")"]

{"sheet":"VBA_Percent","index":11,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,9,1,11],[1,1,1,3]]}
[]
[null,"Formatting Percentage",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Example","Result","Code",null,null,null,null,null,"Example","Result","Code"]
[null,0.88,0.88,"Format(Cells(5, 2), \"Percent\")",null,null,null,null,null,0.88,null,"Format(Cells(5, 2), \"Percent\")"]

{"sheet":"VBA_Logic","index":12,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,1,6,1],[8,1,10,1],[1,9,1,11],[4,9,6,9],[8,9,10,9],[1,1,1,3]]}
[]
[null,"Formatting for Logic Test",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Code",null,null,null,null,null,"Value","Result","Code"]
[null,2,"Yes","Format(Cells(5, 2), \"Yes/No\")",null,null,null,null,null,2,null,"Format(Cells(5, 2), \"Yes/No\")"]
[null,null,true,"Format(Cells(5, 2), \"True/False\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"True/False\")"]
[null,null,"On","Format(Cells(5, 2), \"On/Off\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"On/Off\")"]
[]
[null,0,"No","Format(Cells(9, 2), \"Yes/No\")",null,null,null,null,null,0,null,"Format(Cells(9, 2), \"Yes/No\")"]
[null,null,false,"Format(Cells(9, 2), \"True/False\")",null,null,null,null,null,null,null,"Format(Cells(9, 2), \"True/False\")"]
[null,null,"Off","Format(Cells(9, 2), \"On/Off\")",null,null,null,null,null,null,null,"Format(Cells(9, 2), \"On/Off\")"]

{"sheet":"VBA_Date","index":13,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,9,1,11],[4,9,7,9],[1,1,1,3],[4,1,7,1]]}
[]
[null,"Formatting Date",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Code",null,null,null,null,null,"Value","Result","Code"]
[null,"2003-09-03","2003-09-03","Format(Cells(5, 2), \"General Date\")",null,null,null,null,null,"2003-09-03",null,"Format(Cells(5, 2), \"General Date\")"]
[null,null,"Wednesday, September 3, 2003","Format(Cells(5, 2), \"Long Date\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"Long Date\")"]
[null,null,"2003-09-03","Format(Cells(5, 2), \"Medium Date\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"Medium Date\")"]
[null,null,"2003-09-03","Format(Cells(5, 2), \"Short Date\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"Short Date\")"]

{"sheet":"VBA_Time","index":14,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,9,1,11],[4,9,6,9],[4,1,6,1],[1,1,1,3]]}
[]
[null,"Formatting Time Value",null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value","Result","Code",null,null,null,null,null,"Value","Result","Code"]
[null,"15:25:00","15:25:00","Format(Cells(5, 2), \"Long Time\")",null,null,null,null,null,"15:25:00",null,"Format(Cells(5, 2), \"Long Time\")"]
[null,null,"15:25:00","Format(Cells(5, 2), \"Medium Time\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"Medium Time\")"]
[null,null,"15:25:00","Format(Cells(5, 2), \"Short Time\")",null,null,null,null,null,null,null,"Format(Cells(5, 2), \"Short Time\")"]

{"sheet":"Remind","index":15,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Number","Result","Formula","Result","Formula"]
[null,1234567,{"$f":"FORMAT($B$3,\"Standard\")","v":{"$error":"#NAME?"}},"=FORMAT($B$3,\"Standard\")",{"$f":"TEXT($B$3,\"#,###.00\")","v":"1,234,567.00"},"=TEXT($B$3,\"#,###.00\")"]
[]
[]
[null,"Number","Result","Code","Result","Code"]
[null,1234567,1234567,"=Format(Cells(7, 2), \"Standard\")",null,"Text(Cells(7, 2), \"#,###.00\")"]