{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Keep Trailing Zeros","TEXT Function","IF Function","Apostrophe","VBA","Add Trailing Zeros"],"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":"Keep Trailing Zeros","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Keep Trailing Zeros in Excel"]
[]
[null,"Product","Price","Number to Text","Concatenate"]
[null,"Apple",123,{"$f":"TEXT(C5,\"##0.000\")","v":"123.000"},{"$f":"B5&\" Price: \"&D5","v":"Apple Price: 123.000"}]
[null,"Orange",250,{"$f":"TEXT(C6,\"##0.000\")","v":"250.000"},{"$f":"B6&\" Price: \"&D6","v":"Orange Price: 250.000"}]
[null,"Grape",200.05,"200.050","Grape Price: 200.050"]
[null,"Blueberry",250.05,"250.050","Blueberry Price: 250.050"]
[null,"Pineapple",300.00049999999999,"300.001","Pineapple Price: 300.001"]
[null,null,null,null," "]

{"sheet":"TEXT Function","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Keep Trailing Zeros Using TEXT Function"]
[]
[null,"Product","Price","Number to Text","Concatenate"]
[null,"Apple",123,{"$f":"TEXT(C5,\"##0.000\")","v":"123.000"},{"$f":"B5&\" Price: \"&D5","v":"Apple Price: 123.000"}]
[null,"Orange",250,{"$f":"TEXT(C6,\"##0.000\")","v":"250.000"},{"$f":"B6&\" Price: \"&D6","v":"Orange Price: 250.000"}]
[null,"Grape",200.05,"200.050","Grape Price: 200.050"]
[null,"Blueberry",250.05,"250.050","Blueberry Price: 250.050"]
[null,"Pineapple",300.00049999999999,"300.001","Pineapple Price: 300.001"]
[null,null,null,null," "]

{"sheet":"IF Function","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Keep Trailing Zeros Using IF Function"]
[]
[null,"Product","Price","Number to Text","Concatenate"]
[null,"Apple",123,{"$f":"IF(CELL(\"FORMAT\",C5)=\"F3\", TEXT(C5,\"0.000\"), TEXT(C5, 0))","v":"123.000"},{"$f":"B5&\" Price: \"&D5","v":"Apple Price: 123.000"}]
[null,"Orange",250.5,{"$f":"IF(CELL(\"FORMAT\",C6)=\"F3\", TEXT(C6,\"0.000\"), TEXT(C6, 0))","v":"250.500"},{"$f":"B6&\" Price: \"&D6","v":"Orange Price: 250.500"}]
[null,"Grape",200,"200.000","Grape Price: 200.000"]
[null,"Blueberry",350.5,"350.500","Blueberry Price: 350.500"]
[null,"Pineapple",450,"450.000","Pineapple Price: 450.000"]
[null,null,null,null," "]

{"sheet":"Apostrophe","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Keep Trailing Zeros Using Apostrophe"]
[]
[null,"Product","Price","Number to Text"]
[null,"Apple",123,"123.00"]
[null,"Orange",250,"250.0"]
[null,"Grape",200.05,"200.05"]
[null,"Blueberry",250.05,"250.050"]
[null,"Pineapple",300.00049999999999,"300.0005"]
[null,null,null,null," "]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Keep Trailing Zeros Using VBA"]
[]
[null,"Product","Price","Number to Text"]
[null,"Apple",100.5,{"$f":"TEXT(C5,\"##0.000\")","v":"100.500"}]
[null,"Orange",200,{"$f":"TEXT(C6,\"##0.000\")","v":"200.000"}]
[null,"Grape",300.75,"300.750"]
[null,"Blueberry",400.25,"400.250"]
[null,"Pineapple",500,"500.000"]
[null,null,null,null," "]

{"sheet":"Add Trailing Zeros","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Add Trailing Zeros Using Formula"]
[]
[null,"Product","Price","Trailing Zeros"]
[null,"Apple",123,{"$f":"C5&REPT(\"0\",5-LEN(C5))","v":"12300"}]
[null,"Orange",250,{"$f":"C6&REPT(\"0\",5-LEN(C6))","v":"25000"}]
[null,"Grape",200,"20000"]
[null,"Blueberry",300,"30000"]
[null,"Pineapple",500,"50000"]
[null,null,null,null," "]