Replacing an Number Field with text as in your formula will have impact
on calculations like COUNT() or AVERAGE()
Also your formula doesn't take into account negative numbers
Suppressing the display of zeros in your Options works on your Display,
but it will not suppress your it when
you print
Hi,
you can also format those cells using the user defined cell format # to
suppress so called leading zeroes in cells.
->format->cells->numbers->Format Code: #
Kind regards, Joost
Am 02.06.2020 um 00:51 schrieb David Robley:
There is an option to globally suppress display of zeros - see Too
There is an option to globally suppress display of zeros - see Tools |
Options | OpenOffice Calc | View and uncheck Zero Values in the Display
section.
Since you are not subscribed to this list you may not see all the
replies to your query. To subscribe to Apache OpenOffice mailing lists
go t
Great suite - Thanks.
I love to hide the "0" value in cells yet to be populated and to do so I
use the =IF(Target Cell>0;Actual Formula;"") setup.
This works well for me upon the Target Cell being the result or a manual
entry.
However, this doesn't work when the Target Cell contains a formu
