Submitted by Kim Egekjaer on Tue, 07/31/2012 - 00:00
Forums

A business partner asked the other day how he could suppress any zeros values, so that InterExcel400 would create a blank cell if a value is 0. This is actually possible by setting a custom formatting for the cell in either a used template excel file. My answer was to use this format in the used style:

0.00;-0.00;

The first part (before the first ‘;’) tells the formatting of positive numbers (larger than 0), the second part tells the formatting of negative values (less than 0) and whatever comes after the last ‘;’ sets the format of the 0 value. In this case it is blank, making Excel to suppress the 0.

If you e.g. wanted the negative values to be printed in red you just change the format to this:

0.00;[Red]-0.00;

The manual of InterExcel400 has now been updated and added to the distribution file. You can download the new manual here: http://download.interform400.com/shares/public/IEE.zip