And to think of all of the times I thought I was being so clever by using
Conditional Formating to make the font white on white when the value =0.

Feel the release!

"Jim Thomlinson" wrote:

Tools - Options - View tab and uncheck Zero Values
--
HTH...

Jim Thomlinson


"RajenRajput1" wrote:

Hi,

Does anyone know how to format a cell so that it looks empty when a zero is
put in?

I am using the custom number format of #,##0;(#,##0) so that I can put
company accounts onto a sheet, where negative values appear in brackets. I
want to extend the format so that zeros appear as blanks (or rather, they do
not appear).


When turnover is zero, so far, if I leave the cell blank, the average
function does not take it into consideration. On the other hand, I do not
want any zeros to "appear" on my page or my hard copies as there are lots of
them.

Hard enough as it is, finally, is there also a way to edit my format to make
zeros appear as any other character, for example a hyphen "-" ?

Thank you for your help.

Rajen