On Mar 8, 8:50 am, "
wrote:
I only want excel to populate the field if there
is a positve or negative integer?

I think you mean that you want Excel to __display__ only non-zero
values. Two ways to accomplish that:

=if(expression = 0, "", expression)

Note that that requires the expression to evaluated twice :-(.
Alternatively, create a custom format by clicking on Format - Cells -
Number - Custom. Perhaps the following will meet your needs:

general;-general;