Hi

No, there isn't. The only way to create a really blank cell is to delete the
entry from it - i.e. the formula (manually or through VBA procedure). But
when after that you change data in your workbook, there will be no formula
to reflect new answer anymore.

So better think, how to cope with "" as result.

Arvi Laanemets


"edellav" wrote in message
...
Sort sequence rules place blank cells at the end of both ascending and
descending sorts which is what I want. However, cells that contain "" are
sorted before numbers in descending sorts, which I don't want. I create a
conditional formula to test for division by a cell that is blank, if true,
I
want the result to be a true blank cell, not a cell with "". Is there a
special character code or function that I can use to accomplish this? I'm
using Excel 2002.