Harold, thank you for replying to your own post! It did the trick... almost.
I wanted to force the display of zeros to the right of the decimal if the amount was 1.00, so I changed the #'s to the right of the decimal in the expression you gave me to "#.00" and it worked. Thanks again! Stan ----- Original Message ----- From: Harold Fuchs To: [email protected] Cc: [email protected] Sent: Sunday, January 11, 2009 5:20 AM Subject: Re: [users] Suppressing zeros in cells containing a formula On 11/01/2009 02:33, Stan Labinsky Jr. wrote: Hello all; Using Writer 3.0, how can I suppress the display of a zero value in a cell containing the product (or sum) of a group of other cells? Sorry to reply to my own post but ... Better: In the number formatting pane choose User Defined and enter [<>0]#.##;[=0]" " into the Format Code box. This is conditional formatting. It's in two parts separated by semi-colon. The first part says "#.## if the number is not zero. The second part says " " (4 spaces) if the number is zero. For more details read up on Conditional Formatting in the Help. -- Harold Fuchs London, England Please reply *only* to [email protected]
