Precision As Displayed "Flaw"
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.