Rounding
@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.
Tags:
Answers
-
The Smartsheet maximum for decimals is currently 5 decimal places.
Paul has an alternate solution in this post:
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
