InterExcel400: Using custom formatting for numeric fields
It has been asked how to 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, to download a new copy please visit our download page.
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, to download a new copy please visit our download page.