You can't have it both ways if the reason your formula returns zero instead
of blank is because you would get an error if you use "" instead of 0, if
not just change the formula that returns zero

--
Regards,

Peo Sjoblom

(No private emails please)


"dford" wrote in message
...
I have a formula that returns 0 instead of null. When I sort the column in
assending order the cells with 0 show up first. I need the cells to be
null
so they do not show up first in the sort.