Please help,
I want to convert cells with zero or other values to
blank, so that they are not included in sorting.

Thanks

Rounak

Assuming the cells contain literal values (as opposed to the 0's being the result of formulas),
use Edit/Replace, Find What -- 0, Replace With -- leave blank. Do the same for other values.

On Tue, 2 Sep 2003 20:16:58 -0700, "Ron" wrote:

Please help,
I want to convert cells with zero or other values to
blank, so that they are not included in sorting.

Thanks

Rounak