Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Turn off full precision option

0

Comments

5 comments

  • Mike Davis

    Hi Jenniffer!

    Thanks for the question. I didn't find a global setting to disable it, but from you Spreadsheet Properties, under Formats, there is this option under Formulas.

    You'd have to toggle on for each your Spreadsheets, but if you were to copy a Spreadsheet with this setting, then that would be inherited too. Does that help?

    Let me know what questions you have or if you need anything else. Have a great day in the meantime!

    0
  • Jenniffer Vielman-Vasquez

    Thank you Mike, we have been able to do this for the spreadsheets but what we were hoping was to somehow completely disable the feature so that it is not accidentally used. We try to be diligent in making sure we select As Displayed but we have encountered issues from time to time where a formula is set at full precision and then we have footing issues. 

    0
  • Mike Davis

    Gotcha. That makes sense. I haven't seen a way to do that, though I think it's a good request. I'll submit that suggestion to our Product Team for consideration, for sure.

    0
  • Jenniffer Vielman-Vasquez

    That would be great Mike! Thank you very much.

    0
  • Barbara Glenn

    I would not want anyone in my company to be able to completely disable this as we use as displayed for our rounded footing of reportings lines but full precision for ratio calculations.

    0

Please sign in to leave a comment.