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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!