What does your formula have.
Also check your tools, options, view, uncheck zero values
I just had to uncheck that myself, evidently it is a default.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"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.