Not displaying zeros

R

Rob E

Does anyone know of a way to get Excel to NOT show zeros
that arise as a result of a formula. I want the cells to
appear blank rather than show a zero.

I know I can use functions such as IF, but I am after a
more general setting that would avoid the need to nest my
calculations in other formula/functions (other people have
created the workbooks already, and there is a lot of
calculations!).

Any help would be really appreciated.

Thanks,

Rob E.
 
T

Trevor Shuttleworth

Rob

Tools | Options... | View tab | Window options section - deselect Zero
values

Regards

Trevor
 
S

Simon Shaw

If you just want it for a section, you can modify a default format from:

_-* #,##0_-;-* #,##0_-;_-* "-"_-;_-@_-
to
_-* #,##0_-;-* #,##0_-;_-* ""_-;_-@_-

note I removed the dash between the quotes
 
B

Bert Neuenschwander

You could also selectively assign a custom format to the cell:
Format;Cell;Number: select custom, and enter "0.00;-0.00;;" (don't enter the
quotes). This will show positive and negative numbers with 2 decimals, but a
zero value will be hidden.

Bert
 
Top