Display zero values as blanks on a calc spreadsheet

Most people know that you can set all of the values on a sheet to display blank if the value is the number zero. This can be annoying on some sheets where you want certain columns to show the zeros and others to be blank if the value is zero. There is an easy fix for this.

Use a user-defined (Excel - custom) format of the following type:

[= 0];0.00

You can make the 0.00 whatever number format you want for non zero numbers.


There are currently no comments

New Comment


required (not published)


Australia: 07 3103 2894

International: +61 410 545 357


RSS / Atom