{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Custom Formatting","Using Formula","Multiplier ","Power Query","VBA macros","General Formatting","Number formatting","Dataset (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Dataset","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Remove Percentage Symbol in Excel"]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage"]
[null,"Arian Smith",4598,228.35,0.05]
[null,"Ronald Murdock",3452,120.82,3.5000000000000003E-2]
[null,"Victor Zelensky",6574,275.27999999999997,0.06]
[null,"Rachel Scott",4999,349.93,7.0000000000000007E-2]
[null,"Nevill Longbottom ",9825,527.12,0.08]
[null,"Monica Belucci",2547,422,0.13189999999999999]
[null,"Kristin Stewart",6325,5582.4,0.16]
[null,"Sheldon Cooper",52000,32000,0.1]

{"sheet":"Custom Formatting","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Remove Percentage Symbol in Excel"]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage"]
[null,"Arian Smith",4598,228.35,0.05]
[null,"Ronald Murdock",3452,120.82,3.5000000000000003E-2]
[null,"Victor Zelensky",6574,275.27999999999997,0.06]
[null,"Rachel Scott",4999,349.93,7.0000000000000007E-2]
[null,"Nevill Longbottom ",9825,527.12,0.08]
[null,"Monica Belucci",2547,422,0.13189999999999999]
[null,"Kristin Stewart",6325,5582.4,0.16]
[null,"Sheldon Cooper",52000,32000,0.1]

{"sheet":"Using Formula","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Remove Percentage Symbol in Excel"]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage","Percentage \n(Symbol Removed)"]
[null,"Arian Smith",4598,228.35,0.05,{"$f":"VALUE(LEFT(TEXT(E5,\"00.00%\"),5))","v":5}]
[null,"Ronald Murdock",3452,120.82,3.5000000000000003E-2,{"$f":"VALUE(LEFT(TEXT(E6,\"000.00%\"),5))","v":3.5}]
[null,"Victor Zelensky",6574,275.27999999999997,0.06,6]
[null,"Rachel Scott",4999,349.93,7.0000000000000007E-2,7]
[null,"Nevill Longbottom ",9825,527.12,0.08,8]
[null,"Monica Belucci",2547,422,0.13189999999999999,13.1]
[null,"Kristin Stewart",6325,5582.4,0.16123000000000001,16.100000000000001]
[null,"Sheldon Cooper",52000,32000,0.1,10]

{"sheet":"Multiplier ","index":3,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Remove Percentage Symbol in Excel"]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage","Percentage \n(Symbol Removed)","Formula \nApplied"]
[null,"Arian Smith",4598,228.35,0.05,{"$f":"E5*100","v":5},{"$f":"_xlfn.FORMULATEXT(F5)","v":"=E5*100"}]
[null,"Ronald Murdock",3452,120.82,3.5000000000000003E-2,{"$f":"E6*100","v":3.5000000000000004},{"$f":"_xlfn.FORMULATEXT(F6)","v":"=E6*100"}]
[null,"Victor Zelensky",6574,275.27999999999997,0.06,{"$f":"E7*100","v":6},"=E7*100"]
[null,"Rachel Scott",4999,349.93,7.0000000000000007E-2,{"$f":"E8*100","v":7.0000000000000009},"=E8*100"]
[null,"Nevill Longbottom ",9825,527.12,0.08,8,"=E9*100"]
[null,"Monica Belucci",2547,422,0.13189999999999999,13.19,"=E10*100"]
[null,"Kristin Stewart",6325,5582.4,0.16,16,"=E11*100"]
[null,"Sheldon Cooper",52000,32000,0.1,10,"=E12*100"]

{"sheet":"Power Query","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5]]}
[]
[null,"Remove Percentage Symbol in Excel"]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage","Percentage\n(Rounded Up)"]
[null,"Arian Smith",4598,228.35,0.05,5]
[null,"Ronald Murdock",3452,120.82,3.5000000000000003E-2,3.5]
[null,"Victor Zelensky",6574,275.27999999999997,0.06,6]
[null,"Rachel Scott",4999,349.93,7.0000000000000007E-2,7]
[null,"Nevill Longbottom ",9825,527.12,0.08,8]
[null,"Monica Belucci",2547,422,0.13189999999999999,13.19]
[null,"Kristin Stewart",6325,5582.4,0.16,16]
[null,"Sheldon Cooper",52000,32000,0.1,10]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage\n(Rounded Up)"]
[null,"Arian Smith",4598,228.35,5]
[null,"Ronald Murdock",3452,120.82,3.5]
[null,"Victor Zelensky",6574,275.27999999999997,6]
[null,"Rachel Scott",4999,349.93,7]
[null,"Nevill Longbottom ",9825,527.12,8]
[null,"Monica Belucci",2547,422,13.19]
[null,"Kristin Stewart",6325,5582.4,16]
[null,"Sheldon Cooper",52000,32000,10]

{"sheet":"VBA macros","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Remove Percentage Symbol in Excel"]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage"]
[null,"Arian Smith",4598,228.35,5]
[null,"Ronald Murdock",3452,120.82,3.5000000000000004]
[null,"Victor Zelensky",6574,275.27999999999997,6]
[null,"Rachel Scott",4999,349.93,7.0000000000000009]
[null,"Nevill Longbottom ",9825,527.12,8]
[null,"Monica Belucci",2547,422,13.19]
[null,"Kristin Stewart",6325,5582.4,16]
[null,"Sheldon Cooper",52000,32000,10]

{"sheet":"General Formatting","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Remove Percentage Symbol in Excel"]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage","Percentage\n(Symbol Removed)"]
[null,"Arian Smith",4598,228.35,0.05,0.05]
[null,"Ronald Murdock",3452,120.82,3.5000000000000003E-2,3.5000000000000003E-2]
[null,"Victor Zelensky",6574,275.27999999999997,0.06,0.06]
[null,"Rachel Scott",4999,349.93,7.0000000000000007E-2,7.0000000000000007E-2]
[null,"Nevill Longbottom ",9825,527.12,0.08,0.08]
[null,"Monica Belucci",2547,422,0.13189999999999999,0.13189999999999999]
[null,"Kristin Stewart",6325,5582.4,0.16,0.16]
[null,"Sheldon Cooper",52000,32000,0.1,0.1]

{"sheet":"Number formatting","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Remove Percentage Symbol in Excel"]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage","Percentage\n(Symbol removed)"]
[null,"Arian Smith",4598,228.35,0.05,{"$f":"E5*100","v":5}]
[null,"Ronald Murdock",3452,120.82,3.5000000000000003E-2,{"$f":"E6*100","v":3.5000000000000004}]
[null,"Victor Zelensky",6574,275.27999999999997,0.06,6]
[null,"Rachel Scott",4999,349.93,7.0000000000000007E-2,7.0000000000000009]
[null,"Nevill Longbottom ",9825,527.12,0.08,8]
[null,"Monica Belucci",2547,422,0.13189999999999999,13.19]
[null,"Kristin Stewart",6325,5582.4,0.16,16]
[null,"Sheldon Cooper",52000,32000,0.1,10]

{"sheet":"Dataset (2)","index":8,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Remove Percentage in Excel"]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage"]
[null,"Arian Smith",4598,228.35,0.05]
[null,"Ronald Murdock",3452,120.82,3.5000000000000003E-2]
[null,"Victor Zelensky",6574,275.27999999999997,0.06]
[null,"Rachel Scott",4999,349.93,7.0000000000000007E-2]
[null,"Nevill Longbottom ",9825,527.12,0.08]
[null,"Monica Belucci",2547,422,0.13189999999999999]
[null,"Kristin Stewart",6325,5582.4,0.16]
[null,"Sheldon Cooper",52000,32000,0.1]
[]
[null,"Emplyoee Name","Salary","Bonus","Percentage","Percentage(Symbol Removed)"]
[null,"Arian Smith",4598,228.35,0.05,5]
[null,"Ronald Murdock",3452,120.82,3.5000000000000003E-2,3.5]
[null,"Victor Zelensky",6574,275.27999999999997,0.06,6]
[null,"Rachel Scott",4999,349.93,7.0000000000000007E-2,7]
[null,"Nevill Longbottom ",9825,527.12,0.08,8]
[null,"Monica Belucci",2547,422,0.13189999999999999,13.19]
[null,"Kristin Stewart",6325,5582.4,0.16,16]
[null,"Sheldon Cooper",52000,32000,0.1,10]