{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Sample Datasheet","Comma Style","Currency Format","Custom Format","DOLLAR Function","FIXED Function","TEXT Function","IF,LEN,REPLACE,MID Functions","MID Function","LEFT MID and RIGHT","VBA Code","Summary","Putting Comma After 2 Digits"],"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":"Sample Datasheet","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Putting Comma After 3 Digits"]
[]
[null,"Account Holder","Savings"]
[null,"Mike",25014890]
[null,"Rob",36587020]
[null,"Ben",23058900]
[null,"Leslie",201456300]
[null,"Sarah",152036000]
[null,"Walter",256985600]
[null,"Jessica",146532870]
[null,"Ross",456200000]

{"sheet":"Comma Style","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,null,null,"Mike",25014890]
[null,"Rob",36587020,null,null,"Rob",36587020]
[null,"Ben",23058900,null,null,"Ben",23058900]
[null,"Leslie",201456300,null,null,"Leslie",201456300]
[null,"Sarah",152036000,null,null,"Sarah",152036000]
[null,"Walter",256985600,null,null,"Walter",256985600]
[null,"Jessica",146532870,null,null,"Jessica",146532870]
[null,"Ross",456200000,null,null,"Ross",456200000]

{"sheet":"Currency Format","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,null,null,"Mike",25014890]
[null,"Rob",36587020,null,null,"Rob",36587020]
[null,"Ben",23058900,null,null,"Ben",23058900]
[null,"Leslie",201456300,null,null,"Leslie",201456300]
[null,"Sarah",152036000,null,null,"Sarah",152036000]
[null,"Walter",256985600,null,null,"Walter",256985600]
[null,"Jessica",146532870,null,null,"Jessica",146532870]
[null,"Ross",456200000,null,null,"Ross",456200000]

{"sheet":"Custom Format","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,null,null,"Mike",25014890]
[null,"Rob",36587020,null,null,"Rob",36587020]
[null,"Ben",23058900,null,null,"Ben",23058900]
[null,"Leslie",201456300,null,null,"Leslie",201456300]
[null,"Sarah",152036000,null,null,"Sarah",152036000]
[null,"Walter",256985600,null,null,"Walter",256985600]
[null,"Jessica",146532870,null,null,"Jessica",146532870]
[null,"Ross",456200000,null,null,"Ross",456200000]

{"sheet":"DOLLAR Function","index":4,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,7]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings","Savings With Comma",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,{"$f":"DOLLAR(C6,0)","v":"$25,014,890"},null,null,"Mike",25014890]
[null,"Rob",36587020,{"$f":"DOLLAR(C7,0)","v":"$36,587,020"},null,null,"Rob",36587020]
[null,"Ben",23058900,"$23,058,900",null,null,"Ben",23058900]
[null,"Leslie",201456300,"$201,456,300",null,null,"Leslie",201456300]
[null,"Sarah",152036000,"$152,036,000",null,null,"Sarah",152036000]
[null,"Walter",256985600,"$256,985,600",null,null,"Walter",256985600]
[null,"Jessica",146532870,"$146,532,870",null,null,"Jessica",146532870]
[null,"Ross",456200000,"$456,200,000",null,null,"Ross",456200000]

{"sheet":"FIXED Function","index":5,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,7]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings","Savings With Comma",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,{"$f":"FIXED(C6,0)","v":"25,014,890"},null,null,"Mike",25014890]
[null,"Rob",36587020,{"$f":"FIXED(C7,0)","v":"36,587,020"},null,null,"Rob",36587020]
[null,"Ben",23058900,"23,058,900",null,null,"Ben",23058900]
[null,"Leslie",201456300,"201,456,300",null,null,"Leslie",201456300]
[null,"Sarah",152036000,"152,036,000",null,null,"Sarah",152036000]
[null,"Walter",256985600,"256,985,600",null,null,"Walter",256985600]
[null,"Jessica",146532870,"146,532,870",null,null,"Jessica",146532870]
[null,"Ross",456200000,"456,200,000",null,null,"Ross",456200000]

{"sheet":"TEXT Function","index":6,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,6,2,7],[2,1,2,3]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings","Savings With Comma",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,{"$f":"TEXT(C6,\"00\"\",\"\"000\"\",\"\"000\")","v":"25,014,890"},null,null,"Mike",25014890]
[null,"Rob",36587020,{"$f":"TEXT(C7,\"00\"\",\"\"000\"\",\"\"000\")","v":"36,587,020"},null,null,"Rob",36587020]
[null,"Ben",23058900,"23,058,900",null,null,"Ben",23058900]
[null,"Leslie",201456300,"201,456,300",null,null,"Leslie",201456300]
[null,"Sarah",152036000,"152,036,000",null,null,"Sarah",152036000]
[null,"Walter",256985600,"256,985,600",null,null,"Walter",256985600]
[null,"Jessica",146532870,"146,532,870",null,null,"Jessica",146532870]
[null,"Ross",456200000,"456,200,000",null,null,"Ross",456200000]

{"sheet":"IF,LEN,REPLACE,MID Functions","index":7,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,7]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings","Savings With Comma",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,{"$f":"IF(LEN(C6)=8,REPLACE(C6,3,6,\",\"&MID(C6,3,3))&\",\"&MID(C6,6,3),IF(LEN(C6)=9,REPLACE(C6,4,6,\",\"&MID(C6,4,3))&\",\"&MID(C6,7,3)))","v":"25,014,890"},null,null,"Mike",25014890]
[null,"Rob",36587020,{"$f":"IF(LEN(C7)=8,REPLACE(C7,3,6,\",\"&MID(C7,3,3))&\",\"&MID(C7,6,3),IF(LEN(C7)=9,REPLACE(C7,4,6,\",\"&MID(C7,4,3))&\",\"&MID(C7,7,3)))","v":"36,587,020"},null,null,"Rob",36587020]
[null,"Ben",23058900,"23,058,900",null,null,"Ben",23058900]
[null,"Leslie",201456300,"201,456,300",null,null,"Leslie",201456300]
[null,"Sarah",152036000,"152,036,000",null,null,"Sarah",152036000]
[null,"Walter",256985600,"256,985,600",null,null,"Walter",256985600]
[null,"Jessica",146532870,"146,532,870",null,null,"Jessica",146532870]
[null,"Ross",456200000,"456,200,000",null,null,"Ross",456200000]

{"sheet":"MID Function","index":8,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,7]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings","Savings With Comma",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,{"$f":"MID(C6,1,2)&\",\"&MID(C6,3,3)&\",\"&MID(C6,6,3)","v":"25,014,890"},null,null,"Mike",25014890]
[null,"Rob",36587020,{"$f":"MID(C7,1,2)&\",\"&MID(C7,3,3)&\",\"&MID(C7,6,3)","v":"36,587,020"},null,null,"Rob",36587020]
[null,"Ben",23058900,"23,058,900",null,null,"Ben",23058900]
[null,"Leslie",21456300,"21,456,300",null,null,"Leslie",201456300]
[null,"Sarah",12036000,"12,036,000",null,null,"Sarah",152036000]
[null,"Walter",26985600,"26,985,600",null,null,"Walter",256985600]
[null,"Jessica",16532870,"16,532,870",null,null,"Jessica",146532870]
[null,"Ross",46200000,"46,200,000",null,null,"Ross",456200000]

{"sheet":"LEFT MID and RIGHT","index":9,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,6,2,7],[2,1,2,3]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings","Savings With Comma",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,{"$f":"LEFT(C6,2)&\",\"&MID(C6,3,3)&\",\"&RIGHT(C6,3)","v":"25,014,890"},null,null,"Mike",25014890]
[null,"Rob",36587020,{"$f":"LEFT(C7,2)&\",\"&MID(C7,3,3)&\",\"&RIGHT(C7,3)","v":"36,587,020"},null,null,"Rob",36587020]
[null,"Ben",23058900,"23,058,900",null,null,"Ben",23058900]
[null,"Leslie",21456300,"21,456,300",null,null,"Leslie",201456300]
[null,"Sarah",12036000,"12,036,000",null,null,"Sarah",152036000]
[null,"Walter",26985600,"26,985,600",null,null,"Walter",256985600]
[null,"Jessica",16532870,"16,532,870",null,null,"Jessica",146532870]
[null,"Ross",46200000,"46,200,000",null,null,"Ross",456200000]

{"sheet":"VBA Code","index":10,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,6,2,7],[2,1,2,3]]}
[]
[]
[null,"Putting Comma After 3 Digits",null,null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings","Savings",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,25014890,null,null,"Mike",25014890]
[null,"Rob",36587020,36587020,null,null,"Rob",36587020]
[null,"Ben",23058900,23058900,null,null,"Ben",23058900]
[null,"Leslie",201456300,201456300,null,null,"Leslie",201456300]
[null,"Sarah",152036000,152036000,null,null,"Sarah",152036000]
[null,"Walter",256985600,256985600,null,null,"Walter",256985600]
[null,"Jessica",146532870,146532870,null,null,"Jessica",146532870]
[null,"Ross",456200000,456200000,null,null,"Ross",456200000]

{"sheet":"Summary","index":11,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,1,12,2],[2,1,2,3],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2]]}
[]
[]
[null,"Putting Comma After 3 Digits"]
[]
[null,"Account Holder",null,"Savings"]
[null,"Mike",null,25014890]
[null,"Rob",null,36587020]
[null,"Ben",null,23058900]
[null,"Leslie",null,201456300]
[null,"Sarah",null,152036000]
[null,"Walter",null,256985600]
[null,"Jessica",null,146532870]
[null,"Ross",null,456200000]
[]
[null,"Method","Outcome","Formula"]
[null,"Comma Style",25014890]
[null,"Currency Format",25014890]
[null,"Custom Format",25014890]
[null,"TEXT Function",{"$f":"TEXT(D6,\"00\"\",\"\"000\"\",\"\"000\")","v":"25,014,890"},{"$f":"_xlfn.FORMULATEXT(C19)","v":"=TEXT(D6,\"00\"\",\"\"000\"\",\"\"000\")"}]
[null,"DOLLAR Function",{"$f":"DOLLAR(D6)","v":"$25,014,890.00"},{"$f":"_xlfn.FORMULATEXT(C20)","v":"=DOLLAR(D6)"}]
[null,"FIXED Function",{"$f":"FIXED(D6,0)","v":"25,014,890"},"=FIXED(D6,0)"]
[null,"IF, LEN, REPLACE, MID Functions",{"$f":"IF(LEN(D6)=8,REPLACE(D6,3,6,\",\"&MID(D6,3,3))&\",\"&MID(D6,6,3),IF(LEN(D6)=9,REPLACE(D6,4,6,\",\"&MID(D6,4,3))&\",\"&MID(D6,7,3)))","v":"25,014,890"},"=IF(LEN(D6)=8,REPLACE(D6,3,6,\",\"&MID(D6,3,3))&\",\"&MID(D6,6,3),IF(LEN(D6)=9,REPLACE(D6,4,6,\",\"&MID(D6,4,3))&\",\"&MID(D6,7,3)))"]
[null,"MID Function",{"$f":"MID(D6,1,2)&\",\"&MID(D6,3,3)&\",\"&MID(D6,6,3)","v":"25,014,890"},"=MID(D6,1,2)&\",\"&MID(D6,3,3)&\",\"&MID(D6,6,3)"]
[null,"LEFT, MID, RIGHT Function",{"$f":"LEFT(D6,2)&\",\"&MID(D6,3,3)&\",\"&RIGHT(D6,3)","v":"25,014,890"},"=LEFT(D6,2)&\",\"&MID(D6,3,3)&\",\"&RIGHT(D6,3)"]
[null,"VBA Code",25014890]

{"sheet":"Putting Comma After 2 Digits","index":12,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,7]]}
[]
[]
[null,"Putting Comma After 2 Digits",null,null,null,null,"For Practice"]
[]
[null,"Account Holder","Savings","Savings With Comma",null,null,"Account Holder","Savings"]
[null,"Mike",25014890,{"$f":"MID(C6,1,2)&\",\"&MID(C6,3,6)","v":"25,014890"},null,null,"Mike",25014890]
[null,"Rob",36587020,{"$f":"MID(C7,1,2)&\",\"&MID(C7,3,6)","v":"36,587020"},null,null,"Rob",36587020]
[null,"Ben",23058900,"23,058900",null,null,"Ben",23058900]
[null,"Leslie",21456300,"21,456300",null,null,"Leslie",201456300]
[null,"Sarah",12036000,"12,036000",null,null,"Sarah",152036000]
[null,"Walter",26985600,"26,985600",null,null,"Walter",256985600]
[null,"Jessica",16532870,"16,532870",null,null,"Jessica",146532870]
[null,"Ross",46200000,"46,200000",null,null,"Ross",456200000]