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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.