1.0IQ Accounting Solutionshttps://www.iqaccountingsolutions.com/blogSteve Collinshttps://www.iqaccountingsolutions.com/blog/author/scollins/rich600338<blockquote class="wp-embedded-content" data-secret="vO7T4nHs7s"><a href="https://www.iqaccountingsolutions.com/blog/displaying-decimals-versus-rounding-excel/">Displaying Decimals versus Rounding in Excel</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.iqaccountingsolutions.com/blog/displaying-decimals-versus-rounding-excel/embed/#?secret=vO7T4nHs7s" width="600" height="338" title="“Displaying Decimals versus Rounding in Excel” — IQ Accounting Solutions" data-secret="vO7T4nHs7s" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript"> /*! This file is auto-generated */ !function(c,d){"use strict";var e=!1,o=!1;if(d.querySelector)if(c.addEventListener)e=!0;if(c.wp=c.wp||{},c.wp.receiveEmbedMessage);else if(c.wp.receiveEmbedMessage=function(e){var t=e.data;if(!t);else if(!(t.secret||t.message||t.value));else if(/[^a-zA-Z0-9]/.test(t.secret));else{for(var r,s,a,i=d.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),n=d.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),o=new RegExp("^https?:$","i"),l=0;l<n.length;l++)n[l].style.display="none";for(l=0;l<i.length;l++)if(r=i[l],e.source!==r.contentWindow);else{if(r.removeAttribute("style"),"height"===t.message){if(1e3<(s=parseInt(t.value,10)))s=1e3;else if(~~s<200)s=200;r.height=s}if("link"===t.message)if(s=d.createElement("a"),a=d.createElement("a"),s.href=r.getAttribute("src"),a.href=t.value,!o.test(a.protocol));else if(a.host===s.host)if(d.activeElement===r)c.top.location.href=t.value}}},e)c.addEventListener("message",c.wp.receiveEmbedMessage,!1),d.addEventListener("DOMContentLoaded",t,!1),c.addEventListener("load",t,!1);function t(){if(o);else{o=!0;for(var e,t,r,s=-1!==navigator.appVersion.indexOf("MSIE 10"),a=!!navigator.userAgent.match(/Trident.*rv:11\./),i=d.querySelectorAll("iframe.wp-embedded-content"),n=0;n<i.length;n++){if(!(r=(t=i[n]).getAttribute("data-secret")))r=Math.random().toString(36).substr(2,10),t.src+="#?secret="+r,t.setAttribute("data-secret",r);if(s||a)(e=t.cloneNode(!0)).removeAttribute("security"),t.parentNode.replaceChild(e,t);t.contentWindow.postMessage({message:"ready",secret:r},"*")}}}}(window,document); </script> You can use number formats, such as the comma style or currency style, or the increase/decrease decimals buttons to control how many decimals Excel displays. These are convenient and can be very useful, but they can also lead to some embarrassing problems in how your numbers display. For example if you have 1.254 in cell […]