{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Home Page","Dataset Overview","Set Precision as Displayed","INT Function","CEILING Function","FLOOR Function","VBA to Remove All Decimals","ROUND Function","ROUNDUP Function","ROUNDDOWN Function","TRUNC Function","VBA to Truncate Decimals"],"not_rendered":{"charts":0,"images":1,"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":"Home Page","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"How to Remove Decimals in Excel Formula Bar"]
[]
[null,"Learn the methods to remove decimals from formula bar in Excel. Read the article we provided and practice these in practice section."]
[]
[null,"Prepared By","Seemanto Saha"]
[null,"Reviewed By","Kawser Ahmed"]
[null,"Last Update","2023-10-25"]
[null,"Article Link","How to Remove Decimals in Excel Formula Bar"]
[]
[null,"Examples"]
[]
[null,"Dataset Overview"]
[null,"1. Enable Set Precision as Displayed Option to Remove Decimals in Excel Formula Bar"]
[null,"2. Removing All Decimals from Formula Bar in Excel"]
[null,"   2.1 Apply INT Function and Use Paste As Values Option"]
[null,"   2.2 Remove All Decimals Using CEILING Function and Paste As Values Option"]
[null,"   2.3 Use FLOOR Function to Remove All Decimals"]
[null,"   2.4 Use VBA to Remove All Decimals in Excel Formula Bar"]
[null,"3. Removing Decimals To a Specific Place from Formula Bar"]
[null,"   3.1 Use ROUND Function and Paste as Values Option"]
[null,"   3.2 Apply ROUNDUP Function"]
[null,"   3.3 Use ROUNDDOWN Function"]
[null,"   3.4 Apply TRUNC Function"]
[null,"   3.5 Use VBA to Keep a Specific Number of Decimal Places"]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Dataset Overview","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Decimals in Formula Bar"]
[]
[null,"Numbers"]
[null,50.652999999999999]
[null,23.876000000000001]
[null,54.978000000000002]
[null,25.32]
[null,63.587000000000003]
[null,65.320999999999998]
[null,27.780999999999999]
[null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Hone Page"]

{"sheet":"Set Precision as Displayed","index":2,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Set Precision as Displayed",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers",null,null,null,null,null,null,"Numbers"]
[null,50.652999999999999,null,null,null,null,null,null,50.652999999999999]
[null,23.876000000000001,null,null,null,null,null,null,23.876000000000001]
[null,54.978000000000002,null,null,null,null,null,null,54.978000000000002]
[null,25.32,null,null,null,null,null,null,25.32]
[null,63.587000000000003,null,null,null,null,null,null,63.587000000000003]
[null,65.320999999999998,null,null,null,null,null,null,65.320999999999998]
[null,27.780999999999999,null,null,null,null,null,null,27.780999999999999]
[null,98.643000000000001,null,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Hone Page"]

{"sheet":"INT Function","index":3,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Paste as Values (INT Function)",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers","Truncated Decimals",null,null,null,null,null,"Numbers","Truncated Decimals"]
[null,50.652999999999999,{"$f":"INT(B5)","v":50},null,null,null,null,null,50.652999999999999]
[null,23.876000000000001,{"$f":"INT(B6)","v":23},null,null,null,null,null,23.876000000000001]
[null,54.978000000000002,54,null,null,null,null,null,54.978000000000002]
[null,25.32,25,null,null,null,null,null,25.32]
[null,63.587000000000003,63,null,null,null,null,null,63.587000000000003]
[null,65.320999999999998,65,null,null,null,null,null,65.320999999999998]
[null,27.780999999999999,27,null,null,null,null,null,27.780999999999999]
[null,98.643000000000001,98,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Hone Page"]

{"sheet":"CEILING Function","index":4,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Paste as Values (CEILING Function)",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers","Truncated Decimals",null,null,null,null,null,"Numbers","Truncated Decimals"]
[null,51,{"$f":"CEILING(B5,1)","v":51},null,null,null,null,null,50.652999999999999]
[null,24,{"$f":"CEILING(B6,1)","v":24},null,null,null,null,null,23.876000000000001]
[null,55,55,null,null,null,null,null,54.978000000000002]
[null,26,26,null,null,null,null,null,25.32]
[null,64,64,null,null,null,null,null,63.587000000000003]
[null,66,66,null,null,null,null,null,65.320999999999998]
[null,28,28,null,null,null,null,null,27.780999999999999]
[null,99,99,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Hone Page"]

{"sheet":"FLOOR Function","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Paste as Values (FLOOR Function)",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers","Truncated Decimals",null,null,null,null,null,"Numbers","Truncated Decimals"]
[null,50,{"$f":"FLOOR(B5,1)","v":50},null,null,null,null,null,50.652999999999999]
[null,23,{"$f":"FLOOR(B6,1)","v":23},null,null,null,null,null,23.876000000000001]
[null,54,54,null,null,null,null,null,54.978000000000002]
[null,25,25,null,null,null,null,null,25.32]
[null,63,63,null,null,null,null,null,63.587000000000003]
[null,65,65,null,null,null,null,null,65.320999999999998]
[null,27,27,null,null,null,null,null,27.780999999999999]
[null,98,98,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Hone Page"]

{"sheet":"VBA to Remove All Decimals","index":6,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"VBA to Remove All Decimals",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers",null,null,null,null,null,null,"Numbers"]
[null,50.652999999999999,null,null,null,null,null,null,50.652999999999999]
[null,23.876000000000001,null,null,null,null,null,null,23.876000000000001]
[null,54.978000000000002,null,null,null,null,null,null,54.978000000000002]
[null,25.32,null,null,null,null,null,null,25.32]
[null,63.587000000000003,null,null,null,null,null,null,63.587000000000003]
[null,65.320999999999998,null,null,null,null,null,null,65.320999999999998]
[null,27.78,null,null,null,null,null,null,27.780999999999999]
[null,98.643000000000001,null,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[null,null,null,"Back to Hone Page"]

{"sheet":"ROUND Function","index":7,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Paste as Values (ROUND Function)",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers","Truncated Decimals",null,null,null,null,null,"Numbers","Truncated Decimals"]
[null,50.7,{"$f":"ROUND(B5,1)","v":50.7},null,null,null,null,null,50.652999999999999]
[null,23.9,{"$f":"ROUND(B6,1)","v":23.9},null,null,null,null,null,23.876000000000001]
[null,55,55,null,null,null,null,null,54.978000000000002]
[null,25.3,25.3,null,null,null,null,null,25.32]
[null,63.6,63.6,null,null,null,null,null,63.587000000000003]
[null,65.3,65.3,null,null,null,null,null,65.320999999999998]
[null,27.8,27.8,null,null,null,null,null,27.780999999999999]
[null,98.6,98.6,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Hone Page"]

{"sheet":"ROUNDUP Function","index":8,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Paste as Values (ROUNDUP Function)",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers","Truncated Decimals",null,null,null,null,null,"Numbers","Truncated Decimals"]
[null,50.7,{"$f":"ROUNDUP(B5,1)","v":50.7},null,null,null,null,null,50.652999999999999]
[null,23.9,{"$f":"ROUNDUP(B6,1)","v":23.9},null,null,null,null,null,23.876000000000001]
[null,55,55,null,null,null,null,null,54.978000000000002]
[null,25.4,25.4,null,null,null,null,null,25.32]
[null,63.6,63.6,null,null,null,null,null,63.587000000000003]
[null,65.400000000000006,65.400000000000006,null,null,null,null,null,65.320999999999998]
[null,27.8,27.8,null,null,null,null,null,27.780999999999999]
[null,98.7,98.7,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Hone Page"]

{"sheet":"ROUNDDOWN Function","index":9,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Paste as Values (ROUNDDOWN Function)",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers","Truncated Decimals",null,null,null,null,null,"Numbers","Truncated Decimals"]
[null,50.6,{"$f":"ROUNDDOWN(B5,1)","v":50.6},null,null,null,null,null,50.652999999999999]
[null,23.8,{"$f":"ROUNDDOWN(B6,1)","v":23.8},null,null,null,null,null,23.876000000000001]
[null,54.9,54.9,null,null,null,null,null,54.978000000000002]
[null,25.3,25.3,null,null,null,null,null,25.32]
[null,63.5,63.5,null,null,null,null,null,63.587000000000003]
[null,65.3,65.3,null,null,null,null,null,65.320999999999998]
[null,27.7,27.7,null,null,null,null,null,27.780999999999999]
[null,98.6,98.6,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Hone Page"]

{"sheet":"TRUNC Function","index":10,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Paste as Values (TRUNC Function)",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers","Truncated Decimals",null,null,null,null,null,"Numbers","Truncated Decimals"]
[null,50.6,{"$f":"TRUNC(B5,1)","v":50.6},null,null,null,null,null,50.652999999999999]
[null,23.8,{"$f":"TRUNC(B6,1)","v":23.8},null,null,null,null,null,23.876000000000001]
[null,54.9,54.9,null,null,null,null,null,54.978000000000002]
[null,25.3,25.3,null,null,null,null,null,25.32]
[null,63.5,63.5,null,null,null,null,null,63.587000000000003]
[null,65.3,65.3,null,null,null,null,null,65.320999999999998]
[null,27.7,27.7,null,null,null,null,null,27.780999999999999]
[null,98.6,98.6,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Hone Page"]

{"sheet":"VBA to Truncate Decimals","index":11,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"VBA to Truncate Decimals",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Numbers",null,null,null,null,null,null,"Numbers"]
[null,50.65,null,null,null,null,null,null,50.652999999999999]
[null,23.88,null,null,null,null,null,null,23.876000000000001]
[null,54.98,null,null,null,null,null,null,54.978000000000002]
[null,25.32,null,null,null,null,null,null,25.32]
[null,63.59,null,null,null,null,null,null,63.587000000000003]
[null,65.319999999999993,null,null,null,null,null,null,65.320999999999998]
[null,27.78,null,null,null,null,null,null,27.780999999999999]
[null,98.64,null,null,null,null,null,null,98.643000000000001]
[]
[]
[]
[]
[]
[]
[null,null,null,"Back to Hone Page"]