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


But Google Sheets rounds it down to 13 decimals


How can I increase precision in Google Sheets?

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

enter image description here


  • Google sheets numbers are decimal type up to 15 digits. See stackoverflow.com/a/44534232/14246120
    – Oleg_S
    Commented 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
    Commented Mar 26, 2021 at 1:48


Your Answer

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