Formula Formating
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.
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.
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.
---