ReeKorl

Hi Steve,

You will need to change the formatting of the cells. Set the format to Custom type and use the following format:

0;-0;;@

This basically says if greater or less than zero, use number, otherwise use blank.

You can find more information about this by going into Excel help and typing "Display or hide zero values"

Another, more long-winded way is to use an if-then-else formula in the result cell, ie:

if(g18=0,"",g18)

Hope this helps!