RE: Format cells to make zeros not appear,or be invisible on screen &p

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
.

Relevant Pages

  • Re: Protect Number Format Only
    ... Simply reapplying the text format is easy, ... need to prevent or fix the loss of leading and/or trailing zeros. ... protect all formatting while allowing cell contents to be edited. ...
    (microsoft.public.excel.misc)
  • RE: Using column with numbers and leading zeros
    ... You could either change the format of the cell you are entering the data into ... I have a column with social security number where leding zeros occur ... leading zeros and that these leftpadded strings can be currectly ...
    (microsoft.public.excel.programming)
  • Re: Sort beginning one-line BELOW what should be
    ... I copy a series of zeros from a cell formatted as Text. ... Paste places the zeros in the destination cell and changes its format ...
    (microsoft.public.excel.programming)
  • Re: Stop excel from dropping the 0 in the beginning of a number?
    ... I format the Excel ISBN column to the 10 zeros, ... You can do the entire thing at once with a macro, ...
    (microsoft.public.excel.setup)
  • Re: How do I stop Excel from dropping leading zeros?
    ... Data to import into Excel. ... valid leading zeros and the values are not fixed width. ... Is there a way to disable auto format? ... I also need to drop the last digit (the check ...
    (microsoft.public.excel.misc)