The formula reads =If(sheet1!B138=0."",sheet1!b138) This formula is in Sheet
2. The cell b138 in Sheet 1 is blank. When I sort the cells in Sheet 2 in
ascending order these cells appear first. I have unchecked zero values in
tools/options/view.

"David McRitchie" wrote:

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.