{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sample Data Set","Add Trailing Zeros_2","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":"Sample Data Set","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Data Set"]
[]
[null,"Number","Add Trailing Zeros"]
[null,3]
[null,13]
[null,165]
[null,3554]
[null,98561]
[null,35758]
[null,547689]
[null,987856]

{"sheet":"Add Trailing Zeros_2","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using REPT and LEN Functions"]
[]
[null,"Number","Add Trailing Zeros"]
[null,3,{"$f":"B5&REPT(\"0\",7-LEN(B5))","v":"3000000"}]
[null,13,{"$f":"B6&REPT(\"0\",7-LEN(B6))","v":"1300000"}]
[null,165,"1650000"]
[null,3554,"3554000"]
[null,98561,"9856100"]
[null,35758,"3575800"]
[null,547689,"5476890"]
[null,987856,"9878560"]

{"sheet":"Add Trailing Zeros","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Number","Add Trailing Zeros"]
[null,3,3000000]
[null,13,1300000]
[null,165,1650000]
[null,3554,3554000]
[null,98561,9856100]
[null,35758,3575800]
[null,547689,5476890]
[null,987856,9878560]