| View previous topic :: View next topic |
| Author |
Message |
piper975
General User
Joined: 19 Jan 2012
Posts: 8
|
 Posted: Wed Feb 08, 2012 8:04 am Post subject: [SOLVED] - display summed cell as blank instead of zero |
 |
|
I would like to have a cell return as blank or nothing displayed when the summed value is equal to zero, is there an easy way to do this ?
this would return a value in C16 as "0" if there was no values entered into the C8 to C15 range.
Any questions please ask 
Last edited by piper975 on Wed Feb 08, 2012 8:59 am; edited 1 time in total |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Feb 08, 2012 8:48 am Post subject: |
|
|
Tools>Options>Calc>View>Display zero=OFF
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
piper975
General User
Joined: 19 Jan 2012
Posts: 8
|
| Posted: Wed Feb 08, 2012 8:58 am Post subject: |
|
|
thanks ...
Tools > Options > OpenOffice.rg Calc > View > Display > Zero values
uncheck = OFF
check = ON |
|
| Back to top |
|
|
|
