Formula Formating

sssnell001 shared this question 2 years ago
Answered

I am using a formula to do calculations, but the answer comes in 2 decimals. How do I change this to no (Zero) decimals.

Also if I have millions in numbers, can I format it to separate the numbers to make it easier to read.

Replies (1)

photo
2

Can you change the defined property for the result of the formula from "number" to "integer"? This should round off the decimal places. Or, change its format to currency, delete the currency symbol and choose the number of decimal places you require.

Using the currency format with no currency symbol also adds separators between the millions and thousands groups.

photo
1

That’s a great idea Nick. I’ve previously requested the ability to set decimal places with the number format, but your currency format sans symbol approach should work just as well.

photo
1

Thanks that is working great. Most appreciated

---