Posted 21 September 2022, 6:04 am EST - Updated 3 October 2022, 2:41 am EST
My goal is to show values with no decimal, whole values only.
To demonstrate the issue, I used the Format Cells demo:
When I enter “1568801” in a cell on Row 1 of the formatting, it shows as expected, 1568801.
When I enter “=1568801” in a cell on Row 2, it adds decimals. No matter what the cell styling is, I can’t remove/hide the decimals. I tried setting the style to n0, but no difference was found.
This is present in my app with other sets of formulas, the problem seems to be present for any number in a calc.
Expected result: number formatting on a cell (such as n0) should be respected in the result of a returned value for a formula cell.