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
Where do I fnd documentation of range.createReplaceDescriptor?
Hopefully that will cover how the descriptor works.
In a spreadsheet tracking stock prices I'm currently indexing through
columns setting number formats at 2 decimals if less than $100 and 0
decimals if larger. It works but is s
