Open Office Calc: Leaving Cell Blank when formula result = 0

Using formula in cell, it may show "0" if the result is zero.

To avoid showing "0" and leave it as blank field, perform this:
Select "Tools -> Options..."


Drill down "OpenOffice.org Calc" and select "View"

At "Display" group, uncheck "Zero values"








Popular posts from this blog

Microsoft Word: Make picture background to be transparent

LINE: Change the contact name

Microsoft Visio: How to set default font