Unify number format to certain number of digits, no display
Hello Smart Heads!
I hope you are doing great!
Thanks for great support so far! I am facing another issue, this time with number format.
In my sheet, I have various calculations in place, including % and others. Thus, I sometimes end up with numbers having non-zero digits in the 3+ place after (.). In other words:
These numbers are later-on used for futher calculations. As a results, I observe discrepancies, even for potentially the same values.
Desired outcome would be to ensure that the calculation's result is always in X.XX format. Please note, that we are not talkich here aboout "Increase / Decrease Decimal" option:
Eventhough, we change the display / view over the number, in the calculation we are using all digits available.
As for now, the only option I see, is a helper column, which identifies dot: ( . ) and provide numbers before it and 2 digits after it.
Is there any other potential solution for this?
Thank you guys in advance!
Romano
Best Answer
-
You would use the ROUND function which allows you to tell it how many decimals to round to.
Answers
-
You would use the ROUND function which allows you to tell it how many decimals to round to.
-
Hey @Paul Newcome
Another day, another function! Thank you very much! It obviously works!
Greetings,
Romano!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!