{"id":203410,"date":"2023-12-10T01:20:58","date_gmt":"2023-12-10T01:20:58","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/"},"modified":"2023-12-10T01:20:58","modified_gmt":"2023-12-10T01:20:58","slug":"how-to-remove-after-decimal-value-in-excel","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/","title":{"rendered":"How to remove after decimal value in Excel?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#How_to_remove_after_decimal_value_in_Excel\" title=\"How to remove after decimal value in Excel?\">How to remove after decimal value in Excel?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#FAQs\" title=\"FAQs:\">FAQs:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#1_Can_I_use_the_TRUNC_function_to_remove_decimal_values_from_multiple_cells_at_once\" title=\"1. Can I use the TRUNC function to remove decimal values from multiple cells at once?\">1. Can I use the TRUNC function to remove decimal values from multiple cells at once?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#2_Is_there_a_way_to_remove_decimal_values_without_rounding_the_number\" title=\"2. Is there a way to remove decimal values without rounding the number?\">2. Is there a way to remove decimal values without rounding the number?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#3_Can_I_remove_decimal_values_by_changing_the_cell_format\" title=\"3. Can I remove decimal values by changing the cell format?\">3. Can I remove decimal values by changing the cell format?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#4_Can_I_remove_a_specific_number_of_decimal_places_using_the_TRUNC_function\" title=\"4. Can I remove a specific number of decimal places using the TRUNC function?\">4. Can I remove a specific number of decimal places using the TRUNC function?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#5_Will_using_the_TRUNC_function_affect_the_original_data_in_the_cell\" title=\"5. Will using the TRUNC function affect the original data in the cell?\">5. Will using the TRUNC function affect the original data in the cell?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#6_Is_there_an_alternative_method_to_remove_decimal_values_in_Excel\" title=\"6. Is there an alternative method to remove decimal values in Excel?\">6. Is there an alternative method to remove decimal values in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#7_Can_I_use_the_TRUNC_function_with_negative_numbers\" title=\"7. Can I use the TRUNC function with negative numbers?\">7. Can I use the TRUNC function with negative numbers?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#8_Can_I_remove_decimal_values_without_using_any_functions_in_Excel\" title=\"8. Can I remove decimal values without using any functions in Excel?\">8. Can I remove decimal values without using any functions in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#9_Will_the_TRUNC_function_work_with_text_values_in_Excel\" title=\"9. Will the TRUNC function work with text values in Excel?\">9. Will the TRUNC function work with text values in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#10_Can_I_remove_decimal_values_while_preserving_the_original_number_for_calculations\" title=\"10. Can I remove decimal values while preserving the original number for calculations?\">10. Can I remove decimal values while preserving the original number for calculations?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#11_Does_removing_decimal_values_affect_the_accuracy_of_my_data\" title=\"11. Does removing decimal values affect the accuracy of my data?\">11. Does removing decimal values affect the accuracy of my data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#12_Can_I_undo_the_removal_of_decimal_values_in_Excel\" title=\"12. Can I undo the removal of decimal values in Excel?\">12. Can I undo the removal of decimal values in Excel?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_remove_after_decimal_value_in_Excel\"><\/span>How to remove after decimal value in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Removing after decimal value in Excel can be done using the TRUNC function. The TRUNC function rounds a number down to the nearest integer by truncating the decimal part of the number. Here&#8217;s how you can use the TRUNC function to remove after decimal value in Excel:<\/p>\n<p>1. Start by selecting a cell where you want to display the rounded number.<br \/>\n2. Enter the formula &#8220;=TRUNC(A1)&#8221; in the selected cell, where A1 is the cell containing the number with decimal values that you want to remove.<br \/>\n3. Press Enter to apply the formula. The selected cell will now display the number rounded down to the nearest integer, effectively removing the decimal values.<\/p>\n<p>Now you know how to remove after decimal value in Excel using the TRUNC function. This simple solution can save you time and help keep your data neat and organized.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_I_use_the_TRUNC_function_to_remove_decimal_values_from_multiple_cells_at_once\"><\/span>1. Can I use the TRUNC function to remove decimal values from multiple cells at once?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can apply the TRUNC function to multiple cells by copying and pasting the formula to other cells.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Is_there_a_way_to_remove_decimal_values_without_rounding_the_number\"><\/span>2. Is there a way to remove decimal values without rounding the number?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can use the INT function instead of the TRUNC function if you want to remove decimal values without rounding the number.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Can_I_remove_decimal_values_by_changing_the_cell_format\"><\/span>3. Can I remove decimal values by changing the cell format?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Changing the cell format to a whole number format will not remove the decimal values, but it will only hide them. To actually remove the decimal values, you need to use a formula like TRUNC or INT.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Can_I_remove_a_specific_number_of_decimal_places_using_the_TRUNC_function\"><\/span>4. Can I remove a specific number of decimal places using the TRUNC function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can specify the number of decimal places you want to remove by adjusting the TRUNC function accordingly. For example, &#8220;=TRUNC(A1,2)&#8221; will remove all decimal values except for two decimal places.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Will_using_the_TRUNC_function_affect_the_original_data_in_the_cell\"><\/span>5. Will using the TRUNC function affect the original data in the cell?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>No, using the TRUNC function will not change the original data in the cell. It will only display the rounded number without decimal values in the selected cell.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Is_there_an_alternative_method_to_remove_decimal_values_in_Excel\"><\/span>6. Is there an alternative method to remove decimal values in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Another way to remove decimal values in Excel is by using the ROUND function with a second argument of zero, which rounds the number to the nearest integer.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Can_I_use_the_TRUNC_function_with_negative_numbers\"><\/span>7. Can I use the TRUNC function with negative numbers?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, the TRUNC function works with both positive and negative numbers, rounding them down to the nearest integer by removing the decimal part.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Can_I_remove_decimal_values_without_using_any_functions_in_Excel\"><\/span>8. Can I remove decimal values without using any functions in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you want to remove decimal values without using functions, you can manually delete the decimal values from each cell using the Delete key. However, this method is not efficient for large data sets.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Will_the_TRUNC_function_work_with_text_values_in_Excel\"><\/span>9. Will the TRUNC function work with text values in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>No, the TRUNC function is designed to work with numerical values, so it will not remove decimal values from text values in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Can_I_remove_decimal_values_while_preserving_the_original_number_for_calculations\"><\/span>10. Can I remove decimal values while preserving the original number for calculations?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you want to keep the original number with decimal values for calculations but display a rounded version without decimals, you can use a separate cell to display the rounded number using the TRUNC function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Does_removing_decimal_values_affect_the_accuracy_of_my_data\"><\/span>11. Does removing decimal values affect the accuracy of my data?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Removing decimal values using the TRUNC function or any other method does not affect the accuracy of your data. It simply changes the way the data is displayed.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_I_undo_the_removal_of_decimal_values_in_Excel\"><\/span>12. Can I undo the removal of decimal values in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Once you have removed decimal values using the TRUNC function or any other method, you cannot directly undo this action. However, you can always keep a backup of your original data to revert back if needed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to remove after decimal value in Excel? Removing after decimal value in Excel can be done using the TRUNC function. The TRUNC function rounds a number down to the nearest integer by truncating the decimal part of the number. Here&#8217;s how you can use the TRUNC function to remove after decimal value in Excel: &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to remove after decimal value in Excel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#more-203410\">Read more<span class=\"screen-reader-text\">How to remove after decimal value in Excel?<\/span><\/a><\/p>\n","protected":false},"author":51,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-203410","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to remove after decimal value in Excel?<\/title>\n<meta name=\"description\" content=\"How to remove after decimal value in Excel? Removing after decimal value in Excel can be done using the TRUNC function. The TRUNC function rounds a number\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to remove after decimal value in Excel?\" \/>\n<meta property=\"og:description\" content=\"How to remove after decimal value in Excel? Removing after decimal value in Excel can be done using the TRUNC function. The TRUNC function rounds a number\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-10T01:20:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"164\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Adam Forbes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adam Forbes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/\"},\"author\":{\"name\":\"Adam Forbes\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\"},\"headline\":\"How to remove after decimal value in Excel?\",\"datePublished\":\"2023-12-10T01:20:58+00:00\",\"dateModified\":\"2023-12-10T01:20:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/\"},\"wordCount\":639,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/\",\"name\":\"How to remove after decimal value in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-12-10T01:20:58+00:00\",\"dateModified\":\"2023-12-10T01:20:58+00:00\",\"description\":\"How to remove after decimal value in Excel? Removing after decimal value in Excel can be done using the TRUNC function. The TRUNC function rounds a number\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to remove after decimal value in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\",\"name\":\"Adam Forbes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Adam Forbes\"},\"description\":\"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to remove after decimal value in Excel?","description":"How to remove after decimal value in Excel? Removing after decimal value in Excel can be done using the TRUNC function. The TRUNC function rounds a number","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to remove after decimal value in Excel?","og_description":"How to remove after decimal value in Excel? Removing after decimal value in Excel can be done using the TRUNC function. The TRUNC function rounds a number","og_url":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2023-12-10T01:20:58+00:00","og_image":[{"width":500,"height":164,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","type":"image\/png"}],"author":"Adam Forbes","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Adam Forbes","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/"},"author":{"name":"Adam Forbes","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060"},"headline":"How to remove after decimal value in Excel?","datePublished":"2023-12-10T01:20:58+00:00","dateModified":"2023-12-10T01:20:58+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/"},"wordCount":639,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/","url":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/","name":"How to remove after decimal value in Excel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-12-10T01:20:58+00:00","dateModified":"2023-12-10T01:20:58+00:00","description":"How to remove after decimal value in Excel? Removing after decimal value in Excel can be done using the TRUNC function. The TRUNC function rounds a number","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-remove-after-decimal-value-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to remove after decimal value in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060","name":"Adam Forbes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Adam Forbes"},"description":"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/203410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=203410"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/203410\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=203410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=203410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=203410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}