I got stuck on this simple problem:
For example, I want the first number to display - $737,137,211,231 (instead of $737,137,211,230.603). But there isn’t “rounded to” operator option in the appearance.
How can I solve this problem?
I got stuck on this simple problem:
For example, I want the first number to display - $737,137,211,231 (instead of $737,137,211,230.603). But there isn’t “rounded to” operator option in the appearance.
How can I solve this problem?
Hmm Good question. Does decimal places = 0 work for your situation?
Otherwise maybe you can do the ‘rounded down to’ before you do the formatting.
Does decimal places = 0 work for your situation?
Yes, that worked. The simpliest option as always
Thank you
This topic was automatically closed after 70 days. New replies are no longer allowed.