0

I want to have a number like this in my cell, 18 decimals after decimal point:

10.643958132611619777

But Google Sheets rounds it down to 13 decimals

10.6439581326116

How can I increase precision in Google Sheets?

"Increase decimal places" button just adds trailing zeros, which is not good:

enter image description here

10.643958132611600000

Improve this question
2
  • Google sheets numbers are decimal type up to 15 digits. See stackoverflow.com/a/44534232/14246120
    – Oleg_S
    Mar 25, 2021 at 11:18
  • @Oleg_S Since an answer from StackOverflow doesn't count as a duplicate, perhaps it would be more useful if your comment was posted as an answer. It would also be more helpful for future users looking for an answer. (Just a thought).
    – Tedinoz
    Mar 26, 2021 at 1:48

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.