Hi Johnny.1966, On Thu, Jan 12, 2006 at 10:50:38 +0100, Johnny.1966 wrote:
> If you don't want the column K to show zeroes when nothing is entered in > the corresponding I and J cells, instead of entering =I1*J1, enter > something like =IF(OR(I1="";J1="");"";I1*J1) A better solution is to disable Tools.Options.Calc.View, group Display, checkbox "Zero values". If for any reason zero values are to be displayed in other places of the same document, disabling the display of zero values is also possible by applying a number format similar to 0;-0;; Note the empty third subformat for zero. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
