Maybe someone else can come along and help with that. On sheet2, if you put =N9 the value returned is 0. But you can put =if(isblank(n9),"blank","something") it returns blank. Shrug

Select the columns with the 0s and:
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Custom.
In the Type box, type 0;-0;;@

No clue what that does or why that works, but I verified it does work. Grabbed it from here