Display zero values as blanks on a calc spreadsheet PDF Print E-mail

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.

Trackback(0)
Comments (0)Add Comment
feedSubscribe to this comment's feed

Write comment

busy
 
Paul Whipp Consulting (BN 207 530 56) is owned by and operated for The Whipp Family Trust (ABN 32 507 522 641).