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.
Australia: 07 3103 2894
International: +61 410 545 357
January (1)
October (2)
September (2)
August (1)
July (5)
June (1)
April (9)
March (1)
January (1)
November (1)
November (1)
July (2)
June (2)
April (1)
February (1)
January (1)
December (2)
March (1)
February (3)
December (2)
October (4)
September (1)
May (1)
April (1)
March (3)
February (2)
January (1)
December (1)
November (1)
October (1)
August (4)
May (1)
November (1)
October (1)
September (8)
Comments
There are currently no comments
New Comment