{"id":120,"date":"2018-12-27T17:21:44","date_gmt":"2018-12-27T17:21:44","guid":{"rendered":"https:\/\/www.howtoexcel.info\/Excel\/?p=120"},"modified":"2019-01-04T07:18:47","modified_gmt":"2019-01-04T07:18:47","slug":"round-down","status":"publish","type":"post","link":"https:\/\/www.howtoexcel.info\/Excel\/round-down\/","title":{"rendered":"How to truncate fractions and convert decimals to whole numbers (value changed)?"},"content":{"rendered":"\r\n<p><span style=\"color: #000000;\"> Fractions can be simply deleted with change in values by using the function =ROUNDDOWN(A1,0) where A1 denotes the cell reference number. Please refer to the following excel spreadsheet for example.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"729\" height=\"617\" class=\"wp-image-121\" src=\"https:\/\/www.howtoexcel.info\/Excel\/wp-content\/uploads\/2018\/12\/round_down.jpg\" alt=\"\" srcset=\"https:\/\/www.howtoexcel.info\/Excel\/wp-content\/uploads\/2018\/12\/round_down.jpg 729w, https:\/\/www.howtoexcel.info\/Excel\/wp-content\/uploads\/2018\/12\/round_down-300x254.jpg 300w\" sizes=\"(max-width: 729px) 100vw, 729px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\">Visit <span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.ozgrid.com\/Excel\/excel-rounding.htm\"> https:\/\/www.ozgrid.com\/Excel\/excel-rounding.htm<\/a><\/span> for more rounding options.<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 12px;\"><strong>Search engine keywords for this question<\/strong><\/span><br \/><span style=\"color: #000000; font-size: 10px;\">I want to delete fractions of a decimal number<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">I want to truncate fractions of a decimal number<\/span><\/p>\r\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/120"}],"collection":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":7,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"predecessor-version":[{"id":228,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/120\/revisions\/228"}],"wp:attachment":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}