hiding noughts

[RagDyer]

<Tools> <Options> <View> tab,
And *Uncheck* "Zero Values", under "Window Options".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I would like to show blank instead of zero values in cells on my
template spreadsheet (just for aesthetic reasons). Any pointers?

 

[Pentranch]

I would like to show blank instead of zero values in cells on my
template spreadsheet (just for aesthetic reasons). Any pointers?

 

[David McRitchie]

If you don't want to mess up other things you can format
the column with an empty 3rd slot the zero
using #,##0_);(#,##0);; instead of #,##0_);(#,##0)

To most of us there is a big difference between zero
and empty.

 

[Gord Dibben]

Pent

If your zeros are the result of formulas, you could trap for that in your
formulas.

=IF(A1+B1=0,"",A1+B1)

Gord Dibben Excel MVP