Rounding

Majid Kayani · 04/25/22

@Genevieve P. I hope you are well sorry to as again, please could i have some assistance on the below question.

I want to type in 5979.100258 in a cell, for example, and it's rounding up to 5979.10026 - which I don't want. How can I get my numbers to remain exact?

sorry to direct this one to directly.

Genevieve P. · 04/26/22

Hi @Majid Kayani

The Smartsheet maximum for decimals is currently 5 decimal places.

Paul has an alternate solution in this post:

https://community.smartsheet.com/discussion/70181/long-decimals-7-digit-decimals

However keep in mind that this will store the values as text values, so you wouldn't be able to do math calculations (such as SUM).

Cheers,

Genevieve

Rounding

Answers

Categories