Sorry, error in prior reply. I meant you can format to display 0
decimals (or 2 decimals). You need a Cell Style for each format.
On 4/15/25 18:48, Java Joe wrote:
It will not actually truncate the values to 0 decimals, but you should
be able to format them to display only 2 decimals.
--
T
I think you can do what you need with Conditional Formatting.
It will not actually truncate the values to 0 decimals, but you should
be able to format them to display only 2 decimals.
You need to create a named Cell Format for each display type, then use
Conditional Formatting to set the desi