MS Excel Query

[Maxflyer]

Is it possible to make cells that contain formulas appear empty. I always get 0.00 showing?

[ck4707]

Yes.

Assuming you only want the cell to show a number when it is not zero highlight the cell click on format then conditional formatting.
enter in the boxes cell value is equal to 0

then click on format select white as the colour (assuming you are leaving the cell white!) then ok ok

Hope this helps

CK

[The Nr Fairy]

Or use "IF".

For example, =IF(A1=0,"",A1) will leave the cell blank if cell A1 is 0 otherwise it shows the correct value.

[Maxflyer]

Thanks for the help. Easy when you know how.

Again, many thanks.

[Avtrician]

That just fixed a problem I was having also. Thanks:ok:

[Flying Duck]

Another way is to change the format :

Menu - Format, Cells, Custom, and then type in ;;; (three semi colons)

Formulae and text still exist, but can only be seen in the formulae bar at the top of the screen.

:)

[Agent86]

If you want to hide ALL the zero values without formatting each cell, then in the Tools => Options => View tab untick the "zero values" box and no more zeros.