Precision As Displayed "Flaw"
So why do we get the very poorly worded warning and why has this simple problem not been fixed? Is it a difficult programming issue or has it just not received adequate attention. Not needing =round() and not suffering
from unnoticed rounding errors in reports is after all a huge issue in the minds of the vast majority of users (casual empiricism after providing training to 100000s of business professionals).
Even if this is a programming nightmare, the warning could at least be revised to be useful. After all, the only assumptions that are negatively impacted are digits entered without the benefit of being proceed by the =
sign. Is there any other issue. I don't believe so. Formula are never adversely impacted (if you don't believe this then provide an example). VBA people are welcome to comment (I hope that is an acceptable way to address this audience).
Even more importantly, the feature is never promoted by Microsoft and virtually unknown to the vast majority of users who simply see calculations that use un-displayed precision as errors that must be corrected by using the
=round() function. (If someone would just tell them that there it is toggle switch that as been in the product for 20 years.)
Will Fleenor, Ph.D, CPA, is CFO of K2 Enterprises, LLC, and makes his home outside Hammond, Louisiana.
by The K2 Team - Look here for anything that involves technology and accounting. K2 Enterprises is the largest supplier of technology CPE (Continuing Professional Education) for CPAs, CGAs and CAs in North America. The K2 team routinely reviews software and hardware products from all major publishers and teaches accountants how to use these tools effectively. The entire K2 team has 10+ years of experience, many with 30+ years of technology and accounting experience.